# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

## 10 top values and sorting in pivot table

Hi, I've got a few problems with pivot table:

1) I would like to take just only 10 the biggest values from the "human" field, basing on field "value" which is the amount of sales. I just need the fields which are classified as 'sheep' (because others are: admin etc.). When I've took, in the expression, "<=10" it showed mi just only 8 values. Any help? Is it correctly written?

if(Aggr(rank(sum(value)), human)<=12,

And the second problem is to take, in the same way, 10 the smallest values.

2) Second problem is with sorting that, I've got 2 dimensions and first is sorted correctly, but when I expand the list, there is no changes. Here the expression : if(sum(value), sum(value)). I would like to sort them by the amount of the value.

1 Solution

Accepted Solutions
Highlighted
New Contributor III

## Re: 10 top values and sorting in pivot table

Hi ,

1.For the first problem, will be having direct option to show both top and bottom values. Just click on Dimensions->Limitation

2.For the second problem, for the first dimension it will be correct and for the second dimension the sorting will be for the individual key fields of the first dimension.

Thank you

2 Replies
Highlighted
New Contributor III

## Re: 10 top values and sorting in pivot table

Hi ,

1.For the first problem, will be having direct option to show both top and bottom values. Just click on Dimensions->Limitation

2.For the second problem, for the first dimension it will be correct and for the second dimension the sorting will be for the individual key fields of the first dimension.

Thank you

MVP

## Re: 10 top values and sorting in pivot table

Hi Aleksandra,

For the first one it can happen than two of the top in sales has a password<>'sheep', so they accomplishes the first 'If' but returns false on the 2nd', can you try with: