Top N or Bottom N rows

[ashishpalkar]

Hi There

I want to get Top N or Bottom N rows in Qlik Sense.

Can you suggest how to achieve this?

Thanks in advance.

[sunny_talwar]

May be check here:

Top 5 analysis using Rank fuction

[OmarBenSalem]

Suppose you have a dimension : dim1 and you want to rank your dim1 based on sum(Measure)

do as follow:

a table:

as dimension: dim1

as measure:

rank(aggr(sum(Measure),dim1))