Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
rmlcavalcante
Contributor
Contributor

How to count the total of a sum measure which matchs a condition

Hi, guys. I'm new on Qlik Sense and I'm building an app at work. 

 

I'm making a table which contains PRODUCTS as dimension and UNITS as measure.

 

In PRODUCTS(dimension) I have a limitation with exact value <= 0 

 

So, I would like to be able to show in the totals only the number(COUNT) of PRODUCTS which finds my condition (<=o). 

 

How can I do that? 

 

Thanks in advance. 

Labels (5)
1 Reply
BrunPierre
Partner - Master
Partner - Master

As below

=Count(DISTINCT {$<UNITS = {"<=0"}>} PRODUCTS)