Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
ajit_aarya
Contributor II
Contributor II

Masters filtering and assigning specific ( States as regions)

If(match(State,'CA','OR','WA'),'West area',If(match(State,'TX','LA','MS','AL','FL'),'Gulf area,
If(Match(State,'ME','MA','RI','CT','NJ','DE','MD','VA','PA','NY'),'North-East area')))

 

So I am categorizing states as regions for the master item dimension. Is there any other way for the syntax???

 

Thanks in advance.

Labels (1)
1 Reply
MartW
Partner - Specialist
Partner - Specialist

you can try with the combo Pick (match())