What query expression should I do for less than 20% American? Also, those with less than 40,000 dollars median income?

414
4
01-19-2018 10:44 AM
__17
by
New Contributor II

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!

0 Kudos
4 Replies
MeganMcClain
Occasional Contributor II

You need to "AND' otherwise it will allow those who only qualify with one of those in your selection.

0 Kudos
XanderBakker
Esri Esteemed Contributor

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 > 0.2) sand test against it, and as stated by Megan use the AND operator to filter on income.

__17
by
New Contributor II

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 less than 20%?

XanderBakker
Esri Esteemed Contributor

Very true indeed. Good catch!

0 Kudos