Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
divya_anand
Creator III
Creator III

Bottom 10 ranks on pie chart in Qlik Sense

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable

9 Replies
Anonymous
Not applicable

Making the rank negative might work??

divya_anand
Creator III
Creator III
Author

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
Not applicable

Can you share your .qvf???

Anonymous
Not applicable

Try this.

Capture.PNG

vinieme12
Champion III
Champion III

Hi,

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
divya_anand
Creator III
Creator III
Author

Got it! It works.

Thank you.

divya_anand
Creator III
Creator III
Author

Hi Vineeth,

I tried this. Dint work for me.

vinieme12
Champion III
Champion III

Well it works, post your expression

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
devarasu07
Master II
Master II

Hi Divya,

Try like below (fixed rank)

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

Bottom10.JPG