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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

newbie needs help counting summary records.

My app as multiple records that each have revenue for one ad.  Some ads have $0 for the total revenue for the ad. I need an expression to count the ads that total Zero  and another expression to count the rest.

sample data:

ad1     cost1     5.00

ad1     cost2     0.00

ad1     cost3     6.15

ad2     cost1     0.00

ad2     cost2     0.00

ad3     cost5     8.25

results I need:  Zero $ ads = 1

                       others      = 2

0 Replies