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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sheetal
Contributor II
Contributor II

Displaying bottom 10 non-zero values

I have a bar chart with product as the dimension and sum(sales) as the measure. I am trying to display the bottom 10 products, but only want to display those bottom 10 products which have sum(Sales) > 0. How can I go about achieving this?Thanks for your time.

Labels (1)
1 Reply
Lisa_P
Employee
Employee

Change your sales measure to exclude zero sales.
sum({<sales={">0"}>}sales)