topic If statement for dimension, exclude fields in App Development https://community.qlik.com/t5/App-Development/If-statement-for-dimension-exclude-fields/m-p/1692128#M52876 <P>I have a field, 'Group' that I am using as a dimension. I want to exclude certain values from the dimension, such as 'ABC', 'DEF', and several others. What is the proper syntax for that.</P> Wed, 08 Apr 2020 18:20:00 GMT evansabres 2020-04-08T18:20:00Z If statement for dimension, exclude fields https://community.qlik.com/t5/App-Development/If-statement-for-dimension-exclude-fields/m-p/1692128#M52876 <P>I have a field, 'Group' that I am using as a dimension. I want to exclude certain values from the dimension, such as 'ABC', 'DEF', and several others. What is the proper syntax for that.</P> Wed, 08 Apr 2020 18:20:00 GMT https://community.qlik.com/t5/App-Development/If-statement-for-dimension-exclude-fields/m-p/1692128#M52876 evansabres 2020-04-08T18:20:00Z Re: If statement for dimension, exclude fields https://community.qlik.com/t5/App-Development/If-statement-for-dimension-exclude-fields/m-p/1692131#M52877 <P>You can do this as your dimesion</P><LI-CODE lang="markup">If(Not Match(Group, 'ABC', 'DEF'), Group)</LI-CODE> Wed, 08 Apr 2020 18:29:34 GMT https://community.qlik.com/t5/App-Development/If-statement-for-dimension-exclude-fields/m-p/1692131#M52877 sunny_talwar 2020-04-08T18:29:34Z