Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count,Aggr and IF - Counting zero

Hi Everybody.

I don't know what I'm doing wrong. I have this expression:

COUNT(AGGR(IF($(PRECO_UNIT_SKU)>=$(FAIXA_1) AND $(PRECO_UNIT_SKU)<=$(FAIXA_2),PRODCOR,0),PRODCOR))

If I put the "0", in that condition the result of the expression is "1" , when I remove the "0", the result of the expression is "0".


But, I think that the number 1 which has been shown, is the count of "0", not the item that need to be count.


Please, any idea?


Thanks!

0 Replies