Discussion board where members can get started with Qlik Sense.
I'd like to have the fixed number limitation display the bottom 20 results where "UnitsSold" <> 0.
Unchecking "Include Zero Values" makes it return no results at the moment.
Is this possible using expressions?
Can you please explain what your requirement is more clearly with example?
Here is an example table:
"ItemCode" currently has a fixed number limitation calculated on "UnitsSold" to the bottom twenty. We would like to filter out any results where UnitsSold = 0.
Share screenshot of expression you used and output you are getting without unchecking "Include Zero Value".
Based on what I understood, you could try this.
IN A TEXT BOX,
This will give you a list of ItemCodes where UnitsSold = 0
If this doesn't work you can try:
if(Sum(UnitsSold) =0,ItemCode )
, ItemCode )