topic Top N & Rank in QlikSense in App Development

Top N & Rank in QlikSense

sabahat_quazi — Wed, 17 Oct 2018 09:53:00 GMT

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 — Wed, 17 Oct 2018 10:03:31 GMT

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 — Wed, 17 Oct 2018 11:24:15 GMT

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;