https://community.qlik.com/t5/App-Development/Masters-filtering-and-assigning-specific-States-as-regions/m-p/1949900#M78279 <P>you can try with the combo Pick (match())</P> Wed, 29 Jun 2022 19:30:33 GMT MartW 2022-06-29T19:30:33Z https://community.qlik.com/t5/App-Development/Masters-filtering-and-assigning-specific-States-as-regions/m-p/1949838#M78272 <P><SPAN>If(match(State,'CA','OR','WA'),'West area',If(match(State,'TX','LA','MS','AL','FL'),'Gulf area,</SPAN><BR /><SPAN>If(Match(State,'ME','MA','RI','CT','NJ','DE','MD','VA','PA','NY'),'North-East area'</SPAN><SPAN>)))</SPAN></P> <P>&nbsp;</P> <P><SPAN>So I am categorizing states as regions for the master item dimension. Is there any other way for the syntax???</SPAN></P> <P>&nbsp;</P> <P><SPAN>Thanks in advance.</SPAN></P> Wed, 29 Jun 2022 16:03:17 GMT https://community.qlik.com/t5/App-Development/Masters-filtering-and-assigning-specific-States-as-regions/m-p/1949838#M78272 ajit_aarya 2022-06-29T16:03:17Z https://community.qlik.com/t5/App-Development/Masters-filtering-and-assigning-specific-States-as-regions/m-p/1949900#M78279 <P>you can try with the combo Pick (match())</P> Wed, 29 Jun 2022 19:30:33 GMT https://community.qlik.com/t5/App-Development/Masters-filtering-and-assigning-specific-States-as-regions/m-p/1949900#M78279 MartW 2022-06-29T19:30:33Z