Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
As below
=Count(DISTINCT {$<UNITS = {"<=0"}>} PRODUCTS)