# 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.
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
Valued Contributor

## Re: Bottom 10 ranks on pie chart in Qlik Sense

Try this.

9 Replies
Valued Contributor

## Re: Bottom 10 ranks on pie chart in Qlik Sense

Making the rank negative might work??

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.

Valued Contributor

## Re: Bottom 10 ranks on pie chart in Qlik Sense

Can you share your .qvf???

Valued Contributor

## Re: Bottom 10 ranks on pie chart in Qlik Sense

Try this.

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)

Contributor II

## Re: Bottom 10 ranks on pie chart in Qlik Sense

Got it! It works.

Thank you.

Contributor II

## Re: Bottom 10 ranks on pie chart in Qlik Sense

Hi Vineeth,

I tried this. Dint work for me.

Esteemed Contributor II

## Re: Bottom 10 ranks on pie chart in Qlik Sense

Well it works, post your expression

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)