Bottom 10 ranks on pie chart in Qlik Sense

[divya_anand]

Hi,

I use Qlik Sense 3.1.

I am trying to create a pie chart which shows the bottom 10 ranks instead of the top 10 ranks as shown below

The bottom 10 are included in the "Others" slice in this chart.

How to I create a chart which shows the least 10 rankers?

Thank you.

[Anonymous]

Making the rank negative might work??

[divya_anand]

Hi Shiva,

The expression I'm using for the Pie chart is (sum(marks)) and showing it as a % value in the chart. The pie chart wouldn't show negative values. Where should I provide the negative expression?

Thank you.

[Anonymous]

Can you share your .qvf???

[Anonymous · Accepted solution]

Try this.

[vinieme12]

Hi,

Suppose your expression is Rank(Sum(Sales),1,1)  to rank bottom 10 change it to Rank(-Sum(Sales),1,1)

[divya_anand]

Got it! It works.

Thank you.

[divya_anand]

Hi Vineeth,

I tried this. Dint work for me.

[vinieme12]

Well it works, post your expression

[devarasu07]

Hi Divya,

Try like below (fixed rank)

=If(Aggr(Rank(-Sum(Revenue)) <= 10,Customer),Customer)