Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be check here:
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))