topic How to use set in expression in QlikView https://community.qlik.com/t5/QlikView/How-to-use-set-in-expression/m-p/164955#M37454 <HTML><HEAD></HEAD><BODY><P><EM>if(Findoneof(Category,'AB')&lt;&gt;0,1,0)</EM> should work too</P></BODY></HTML> Wed, 12 Jan 2011 07:35:19 GMT Anonymous 2011-01-12T07:35:19Z How to use set in expression https://community.qlik.com/t5/QlikView/How-to-use-set-in-expression/m-p/164953#M37452 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have one scenario, I have a field named 'Category', it has three values:A,B,C</P><P>I have one object, say label, I want to show or hide it based on the Category.</P><P>If Category is A or B , it shows.</P><P>I know we can use a expression to achieve. But how to use like a set, for example: <STRONG>Category='A,B'</STRONG> ?</P></BODY></HTML> Wed, 12 Jan 2011 07:29:39 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-in-expression/m-p/164953#M37452 2011-01-12T07:29:39Z How to use set in expression https://community.qlik.com/t5/QlikView/How-to-use-set-in-expression/m-p/164954#M37453 <HTML><HEAD></HEAD><BODY><P>You could do:</P><P><EM>If(Category='A' or Category='B', 1, 0)</EM></P></BODY></HTML> Wed, 12 Jan 2011 07:33:12 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-in-expression/m-p/164954#M37453 Anonymous 2011-01-12T07:33:12Z How to use set in expression https://community.qlik.com/t5/QlikView/How-to-use-set-in-expression/m-p/164955#M37454 <HTML><HEAD></HEAD><BODY><P><EM>if(Findoneof(Category,'AB')&lt;&gt;0,1,0)</EM> should work too</P></BODY></HTML> Wed, 12 Jan 2011 07:35:19 GMT https://community.qlik.com/t5/QlikView/How-to-use-set-in-expression/m-p/164955#M37454 Anonymous 2011-01-12T07:35:19Z