Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ramya_mudunuri
New Contributor

Bottom 10 in a bar chart excluding zeros

Hi,

I am trying to get bottom 10 stores on a bar chart based on the total sales but would like to exclude the store which shows 0 sales.

For example

StoreSales
A10
B20
C40
D30
E90
F0
G0
H0
I0
J0

In this case if i try to show the bottom 5, i would get the results with F G H I J but instead i would like to see A B D C E. How can i achieve this?

Tried using data handling> uncheck zero values..but no results

2 Replies
MVP
MVP

Re: Bottom 10 in a bar chart excluding zeros

May be use this expression

Sum({<Store = {"=Sum(Sales) > 0"}>}Sales)

xufei123
Valued Contributor

Re: Bottom 10 in a bar chart excluding zeros

Sum({<Store={"=sum(Sales)>0 and rank(1/sum(Sales))<=5"}>}Sales)

Community Browser