topic Re: What query expression should I do for less than 20% American? Also, those with less than 40,000 dollars median income? in ArcGIS Mapping and Charting Questions https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160826#M544 <HTML><HEAD></HEAD><BODY><P>Very true indeed. Good catch!</P></BODY></HTML> Sun, 21 Jan 2018 16:21:48 GMT XanderBakker 2018-01-21T16:21:48Z What query expression should I do for less than 20% American? Also, those with less than 40,000 dollars median income? https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160822#M540 <HTML><HEAD></HEAD><BODY><P>I'm somewhat confused with how to do query expressions. Would for both of these, would I use 'AND' or 'OR' in the query expression to combine them? Thanks!</P></BODY></HTML> Fri, 19 Jan 2018 18:44:40 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160822#M540 __17 2018-01-19T18:44:40Z Re: What query expression should I do for less than 20% American? Also, those with less than 40,000 dollars median income? https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160823#M541 <HTML><HEAD></HEAD><BODY><P>You need to "AND' otherwise it will&nbsp;allow those who only qualify with one of those in your selection.</P></BODY></HTML> Fri, 19 Jan 2018 18:50:26 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160823#M541 MeganMcClain 2018-01-19T18:50:26Z Re: What query expression should I do for less than 20% American? Also, those with less than 40,000 dollars median income? https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160824#M542 <HTML><HEAD></HEAD><BODY><P>What data do you have? In case you have fields with counts per ethnic group, you will have to determine the percentage (Americans / sum of all ethnic group &gt; 0.2) sand test against it, and as stated by Megan use the AND operator to filter&nbsp;on income.</P></BODY></HTML> Fri, 19 Jan 2018 18:55:25 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160824#M542 XanderBakker 2018-01-19T18:55:25Z Re: What query expression should I do for less than 20% American? Also, those with less than 40,000 dollars median income? https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160825#M543 <HTML><HEAD></HEAD><BODY><P>Wouldn't it be a less than symbol instead of a greater than symbol? Simply due to the fact that that I want to exclude features with <EM>less than</EM> 20%?</P></BODY></HTML> Sun, 21 Jan 2018 03:56:44 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160825#M543 __17 2018-01-21T03:56:44Z Re: What query expression should I do for less than 20% American? Also, those with less than 40,000 dollars median income? https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160826#M544 <HTML><HEAD></HEAD><BODY><P>Very true indeed. Good catch!</P></BODY></HTML> Sun, 21 Jan 2018 16:21:48 GMT https://community.esri.com/t5/arcgis-mapping-and-charting-questions/what-query-expression-should-i-do-for-less-than-20/m-p/160826#M544 XanderBakker 2018-01-21T16:21:48Z