topic Set analyses ? - using OR in QlikView https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211922#M504678 <HTML><HEAD></HEAD><BODY><P>this should do:</P><P>sum( $ {&lt; a = {'1','2'} &gt;} b)</P><P></P><P>Anita</P></BODY></HTML> Thu, 14 Jan 2010 11:38:06 GMT Anonymous 2010-01-14T11:38:06Z Set analyses ? - using OR https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211921#M504677 <HTML><HEAD></HEAD><BODY><P>hello,</P><P></P><P><B>how can I convert this function - sum ( distinct IF (a='1'</B> <B><I>OR</I></B> a='2 , (b) , 0)) into set analyses function ?</P><P>sum ( { $&lt;a = {'1' ???????????? '2'}&gt;} b)</P><P></P><P></P></BODY></HTML> Thu, 14 Jan 2010 11:33:39 GMT https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211921#M504677 ivan_will 2010-01-14T11:33:39Z Set analyses ? - using OR https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211922#M504678 <HTML><HEAD></HEAD><BODY><P>this should do:</P><P>sum( $ {&lt; a = {'1','2'} &gt;} b)</P><P></P><P>Anita</P></BODY></HTML> Thu, 14 Jan 2010 11:38:06 GMT https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211922#M504678 Anonymous 2010-01-14T11:38:06Z Set analyses ? - using OR https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211923#M504679 <HTML><HEAD></HEAD><BODY><P><span class="lia-unicode-emoji" title=":disappointed_face:">😞</span> no, it doesn't work !</P></BODY></HTML> Thu, 14 Jan 2010 13:20:26 GMT https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211923#M504679 ivan_will 2010-01-14T13:20:26Z Set analyses ? - using OR https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211924#M504680 <HTML><HEAD></HEAD><BODY><P>If that concerns to distinct, try</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum({&lt; a = {"1","2"} &gt;} DISTINCT b)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Thu, 14 Jan 2010 13:23:58 GMT https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211924#M504680 Miguel_Angel_Baeyens 2010-01-14T13:23:58Z Set analyses ? - using OR https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211925#M504684 <HTML><HEAD></HEAD><BODY><P>Even, when working with numeric values</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Sum({&lt; a = {1,2} &gt;} DISTINCT b)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Thu, 14 Jan 2010 13:29:30 GMT https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211925#M504684 Miguel_Angel_Baeyens 2010-01-14T13:29:30Z Set analyses ? - using OR https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211926#M504685 <HTML><HEAD></HEAD><BODY><P>No , it does not work again ! I need - <B>OR</B></P><P>This function Sum({&lt; a = {1,2} &gt;} b) = + between 1and 2 /////// , - means +</P></BODY></HTML> Thu, 14 Jan 2010 13:45:46 GMT https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211926#M504685 ivan_will 2010-01-14T13:45:46Z Set analyses ? - using OR https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211927#M504686 <HTML><HEAD></HEAD><BODY><P><I>a = {1,2}</I> means that <I>a</I> should be 1 <B>or</B> 2</P></BODY></HTML> Thu, 14 Jan 2010 13:55:54 GMT https://community.qlik.com/t5/QlikView/Set-analyses-using-OR/m-p/211927#M504686 Anonymous 2010-01-14T13:55:54Z