Discussion board where members can get started with Qlik Sense.
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?
Go to Solution.
Making the rank negative might work??
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?
Can you share your .qvf???
Suppose your expression is Rank(Sum(Sales),1,1) to rank bottom 10 change it to Rank(-Sum(Sales),1,1)
Got it! It works.
I tried this. Dint work for me.
Well it works, post your expression
Try like below (fixed rank)
=If(Aggr(Rank(-Sum(Revenue)) <= 10,Customer),Customer)