Top N & Rank in QlikSense

[sabahat_quazi]

Hi All,

I am trying to Implement Top-N functionality in Qlik Sense.

Below is my sample data

Now the requirement is to filter rows where rank is  <= 5

Appreciate any suggestion/ help.

Regards,

Sabahat

[maddysalunke]

Hi Sabahat,

If there is a Column "Rank" already present in you dataset you only need to put a calculated Dimension in your chart.

If(Rank<=5, Customer)

and you can also use this in your set expression

count({<Rank<={1,2,3,4,5}>}Account)

Thanks,

Madhura

[undergrinder]

Hi Sabahat,

try change the Rank dimension to

=if(Rank<=5,Rank,null())

then exclude nulls in the table.

If you want to achieve this in load script then

Table:

Load * Resident/From

Where Rank<=5;

G.