topic Re: Set Analysis question in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/626897#M477057 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.399999618530273px;">Try</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.399999618530273px;">Count({$&lt;CYFlag={1},[Shipping Agent Code]-={'KASSA'},Quantity={"&gt;0"}&gt;}DISTINCT(Document_Nr))</SPAN></P></BODY></HTML> Thu, 08 May 2014 13:00:49 GMT MK_QSL 2014-05-08T13:00:49Z Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/626896#M477056 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-size: 8pt;">Why gives these 2 rows not the same answer ?</SPAN></P><P></P><P><SPAN style="color: #000000;"><SPAN style="font-size: 8pt;">Count(</SPAN><SPAN style="font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="font-size: 8pt;">if</SPAN><SPAN style="font-size: 8pt;">((</SPAN><SPAN style="font-size: 8pt;">Quantity</SPAN><SPAN style="font-size: 8pt;">&lt;&gt;0 </SPAN><SPAN style="font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="font-size: 8pt;">CYFlag</SPAN><SPAN style="font-size: 8pt;">=1 </SPAN><SPAN style="font-size: 8pt;">and</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="font-size: 8pt;">[Shipping Agent Code]</SPAN><SPAN style="font-size: 8pt;">&lt;&gt;'KASSA'),</SPAN><SPAN style="font-size: 8pt;">Document_Nr</SPAN><SPAN style="font-size: 8pt;">)))<BR /><BR /></SPAN></SPAN><SPAN style="color: #000000; font-size: 8pt;">Count({$&lt;CYFlag={1},[Shipping Agent Code]-={'KASSA'},Quantity-={0}&gt;}DISTINCT(Document_Nr)) </SPAN></P><P></P></BODY></HTML> Thu, 08 May 2014 12:59:46 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/626896#M477056 tanjavarwijk 2014-05-08T12:59:46Z Re: Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/626897#M477057 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.399999618530273px;">Try</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 10.399999618530273px;">Count({$&lt;CYFlag={1},[Shipping Agent Code]-={'KASSA'},Quantity={"&gt;0"}&gt;}DISTINCT(Document_Nr))</SPAN></P></BODY></HTML> Thu, 08 May 2014 13:00:49 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/626897#M477057 MK_QSL 2014-05-08T13:00:49Z Re: Set Analysis question https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/626898#M477058 <HTML><HEAD></HEAD><BODY><P>Quantity can also be negative</P></BODY></HTML> Thu, 08 May 2014 13:05:38 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-question/m-p/626898#M477058 tanjavarwijk 2014-05-08T13:05:38Z