Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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())