Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
divya_anand
Contributor II

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.

Tags (2)
1 Solution

Accepted Solutions
laddu_927
Valued Contributor

Re: Bottom 10 ranks on pie chart in Qlik Sense

Try this.

Capture.PNG

9 Replies
laddu_927
Valued Contributor

Re: Bottom 10 ranks on pie chart in Qlik Sense

Making the rank negative might work??

divya_anand
Contributor II

Re: Bottom 10 ranks on pie chart in Qlik Sense

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.

laddu_927
Valued Contributor

Re: Bottom 10 ranks on pie chart in Qlik Sense

Can you share your .qvf???

laddu_927
Valued Contributor

Re: Bottom 10 ranks on pie chart in Qlik Sense

Try this.

Capture.PNG

vinieme12
Esteemed Contributor II

Re: Bottom 10 ranks on pie chart in Qlik Sense

Hi,

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

divya_anand
Contributor II

Re: Bottom 10 ranks on pie chart in Qlik Sense

Got it! It works.

Thank you.

divya_anand
Contributor II

Re: Bottom 10 ranks on pie chart in Qlik Sense

Hi Vineeth,

I tried this. Dint work for me.

vinieme12
Esteemed Contributor II

Re: Bottom 10 ranks on pie chart in Qlik Sense

Well it works, post your expression

devarasu07
Honored Contributor II

Re: Bottom 10 ranks on pie chart in Qlik Sense

Hi Divya,

Try like below (fixed rank)

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

Bottom10.JPG

Community Browser