Show in a Qlik table only the first 5 Company with the biggest values

[pascos88]

Hi all, 

I am looking for a set analysis in order to show in a table only the first 5 company with the biggest (max) values. 

Company  Values

A                   100

B                   99

C                  99

D                 97

E                96

All the rest of the companies shouldn't showing up, 

Thank you for any help 

Best

[richard_chilvers]

Check out the 'Dimension Limits' tab in your chart.

[pascos88]

Thanks for the answer. 

Can you please give to me a bit more details? 

Best

[jyothish8807 · Accepted solution]

Try this:

if(Aggr(Rank(Sum(Value)),Company ) <=5,Sum(Value))

[pascos88]

Sorry again, 

If I also would like to have the lowest 5?  what will change in the formula? 

[jyothish8807]

Try this 🙂

if(Aggr(Rank(-Sum(Values)),Company) <=5, Sum(Values))

[pascos88]

Works perfectly. 

Thanks a lot 🙂 

[jyothish8807]

You are welcome 🙂