Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ashishpalkar
Contributor II

Top N or Bottom N rows

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.

2 Replies
MVP
MVP

Re: Top N or Bottom N rows

omarbensalem
Esteemed Contributor

Re: Top N or Bottom N rows

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))