topic Re: AGGR in QlikView https://community.qlik.com/t5/QlikView/AGGR/m-p/891776#M1017417 <HTML><HEAD></HEAD><BODY><P>thanks mate </P></BODY></HTML> Fri, 10 Apr 2015 08:08:15 GMT Anonymous 2015-04-10T08:08:15Z AGGR https://community.qlik.com/t5/QlikView/AGGR/m-p/891774#M1017415 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have a situation where in have to sum up the quantity and count the batch but with the condition where sum of quantity&lt;&gt;0, please help. Data files attached herewith</P><P></P><P>Thanks in Advance</P><P>Vinayagam !</P></BODY></HTML> Fri, 10 Apr 2015 07:40:59 GMT https://community.qlik.com/t5/QlikView/AGGR/m-p/891774#M1017415 Anonymous 2015-04-10T07:40:59Z Re: AGGR https://community.qlik.com/t5/QlikView/AGGR/m-p/891775#M1017416 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>sum(aggr(if(SUM({&lt;POSTINGNUM={"&lt;=$(TEST)"}&gt;}Quantity1_MSEG1)&gt;0,COUNT(DISTINCT(BATCH)),0),BATCH))</P></BODY></HTML> Fri, 10 Apr 2015 07:48:27 GMT https://community.qlik.com/t5/QlikView/AGGR/m-p/891775#M1017416 stabben23 2015-04-10T07:48:27Z Re: AGGR https://community.qlik.com/t5/QlikView/AGGR/m-p/891776#M1017417 <HTML><HEAD></HEAD><BODY><P>thanks mate </P></BODY></HTML> Fri, 10 Apr 2015 08:08:15 GMT https://community.qlik.com/t5/QlikView/AGGR/m-p/891776#M1017417 Anonymous 2015-04-10T08:08:15Z