Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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!