Show top 5 ranked records based record created date

sukantoB — Sun, 14 Feb 2021 05:22:26 GMT

How to show only the top 5 ranked records based on created date(or any other dimension) in a Table chart or any other chart? I have a simple data set as below

[created]:
LOAD * INLINE
[
Name,Created
AAA,12.02.2021
BBB,13.02.2021
CCC,14.02.2021
DDD,15.02.2021
EEE,16.02.2021
FFF,17.02.2021
GGG,18.02.2021
];

I have ranked the records based on the filed 'Created' as below, and I would like to see only the first 5 records (rank 1 - 5)

Is there an option inbuilt in qliksense? If now, whats the workaround? Please advise.

Regards

Sukanto Bhowmik

Re: Show top 5 ranked records based record created date

PradeepK — Sun, 14 Feb 2021 06:18:44 GMT

Created a calculated dimension..

Aggr( Only({< Name = {"= Rank(Created,4)<=5 "} >}Name) ,Name)

disable "Include Null values" option.

Hope this helps!!

topic Re: Show top 5 ranked records based record created date in App Development

Show top 5 ranked records based record created date

Re: Show top 5 ranked records based record created date