Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
LisaG
Contributor II
Contributor II

Count if sum(value) ist not 0

Hi,

I have to count the date only if the net revenue on the day is not equal to 0. Also the net revenue needs to be summed up to the date before the condition: net revenue not equal to 0 is checked.

I am trying to use this, but it doesn't work:

Count({<[%DAT]={sum([net revenue]) <> 0}>} distinct [%DAT])

Thanks a lot,

Lisa

Labels (2)
1 Solution

Accepted Solutions
Gysbert_Wassenaar

Try: Count({<[%DAT]={"=sum([net revenue]) <> 0"}>} distinct [%DAT])


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Try: Count({<[%DAT]={"=sum([net revenue]) <> 0"}>} distinct [%DAT])


talk is cheap, supply exceeds demand
LisaG
Contributor II
Contributor II
Author

Thanks a lot, it worked!