topic Count,Aggr and IF - Counting zero in QlikView https://community.qlik.com/t5/QlikView/Count-Aggr-and-IF-Counting-zero/m-p/1229478#M872932 <HTML><HEAD></HEAD><BODY><P>Hi Everybody.</P><P></P><P>I don't know what I'm doing wrong. I have this expression:</P><P></P><P>COUNT(AGGR(IF($(PRECO_UNIT_SKU)&gt;=$(FAIXA_1) AND $(PRECO_UNIT_SKU)&lt;=$(FAIXA_2),PRODCOR<STRONG>,<SPAN style="color: #ff0000;">0</SPAN></STRONG><SPAN style="color: #000000;">)</SPAN>,PRODCOR))</P><P></P><P>If I put the "<SPAN style="color: #ff6600;"><STRONG>0</STRONG></SPAN>", in that condition the result of the expression is "<SPAN style="color: #ff0000;">1"<SPAN style="color: #000000;"> , when I remove the "<STRONG style=": ; color: #ff0000;">0</STRONG>", the result of the expression is "0".</SPAN></SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">But, I think that the number 1 <SPAN lang="en">which has been shown, is the count of "0", not the item that need to be count.</SPAN></SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Please, any idea?</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Thanks!<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Count,Aggr and IF - Counting zero https://community.qlik.com/t5/QlikView/Count-Aggr-and-IF-Counting-zero/m-p/1229478#M872932 <HTML><HEAD></HEAD><BODY><P>Hi Everybody.</P><P></P><P>I don't know what I'm doing wrong. I have this expression:</P><P></P><P>COUNT(AGGR(IF($(PRECO_UNIT_SKU)&gt;=$(FAIXA_1) AND $(PRECO_UNIT_SKU)&lt;=$(FAIXA_2),PRODCOR<STRONG>,<SPAN style="color: #ff0000;">0</SPAN></STRONG><SPAN style="color: #000000;">)</SPAN>,PRODCOR))</P><P></P><P>If I put the "<SPAN style="color: #ff6600;"><STRONG>0</STRONG></SPAN>", in that condition the result of the expression is "<SPAN style="color: #ff0000;">1"<SPAN style="color: #000000;"> , when I remove the "<STRONG style=": ; color: #ff0000;">0</STRONG>", the result of the expression is "0".</SPAN></SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">But, I think that the number 1 <SPAN lang="en">which has been shown, is the count of "0", not the item that need to be count.</SPAN></SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Please, any idea?</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Thanks!<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Count-Aggr-and-IF-Counting-zero/m-p/1229478#M872932 2020-11-25T16:16:04Z