Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Community,
I want to show in a pivot table the products that are Out of stock at least once on the selected period
here's an exemple:
Hi,
If you need to use expressions only and are in a hurry, a clunky way might be to add another expression that acts as a counter:
=if(isnum(if(Count(DISTINCT TOTAL<Prod> status) >1,sum({<status={'Out'}>}stock))),1,0)
Then suppress zeros and it will only show any rows where your original expression results in a number.
I'm sure there is a more elegant way though!
The result is this (not great, but I think the better solution lies in scripting)