Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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