Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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