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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 II
Partner - Master II

As below

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