topic Re: OR + AND in SET in QlikView https://community.qlik.com/t5/QlikView/OR-AND-in-SET/m-p/432050#M1158207 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try with this</P><P></P><P>=count({&lt;Account__Number=P({&lt;Platform_Product_Line={'MRO','MQ'}&gt;}Account__Number)&gt; * &lt;Account__Number=P({&lt;Platform_Product_Line={'THER'}&gt;}Account__Number)&gt;}DISTINCT Account__Number)</P></BODY></HTML> Fri, 14 Dec 2012 19:06:23 GMT MayilVahanan 2012-12-14T19:06:23Z OR + AND in SET https://community.qlik.com/t5/QlikView/OR-AND-in-SET/m-p/432049#M1158206 <HTML><HEAD></HEAD><BODY><P>The attached shows Acct with a product or set of products, but I want to see where it has product MQ or MRO AND THER.&nbsp; Is it two separate sets?&nbsp; I cannot seem to get the syntax.&nbsp; The text box "Acct with MQ or MRO AND THER" shows the expected value.</P></BODY></HTML> Thu, 13 Dec 2012 00:18:42 GMT https://community.qlik.com/t5/QlikView/OR-AND-in-SET/m-p/432049#M1158206 Anonymous 2012-12-13T00:18:42Z Re: OR + AND in SET https://community.qlik.com/t5/QlikView/OR-AND-in-SET/m-p/432050#M1158207 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try with this</P><P></P><P>=count({&lt;Account__Number=P({&lt;Platform_Product_Line={'MRO','MQ'}&gt;}Account__Number)&gt; * &lt;Account__Number=P({&lt;Platform_Product_Line={'THER'}&gt;}Account__Number)&gt;}DISTINCT Account__Number)</P></BODY></HTML> Fri, 14 Dec 2012 19:06:23 GMT https://community.qlik.com/t5/QlikView/OR-AND-in-SET/m-p/432050#M1158207 MayilVahanan 2012-12-14T19:06:23Z Re: OR + AND in SET https://community.qlik.com/t5/QlikView/OR-AND-in-SET/m-p/432051#M1158208 <HTML><HEAD></HEAD><BODY><P>Thank you so much!</P></BODY></HTML> Fri, 14 Dec 2012 23:12:58 GMT https://community.qlik.com/t5/QlikView/OR-AND-in-SET/m-p/432051#M1158208 Anonymous 2012-12-14T23:12:58Z