Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
sukantoB
Contributor II
Contributor II

Show top 5 ranked records based record created date

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)

sukantoB_0-1613280003128.png

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

 

Regards

Sukanto Bhowmik

1 Solution

Accepted Solutions
PradeepK
Creator II
Creator II

Created a calculated dimension.. 

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

disable "Include Null values" option.

 

Hope this helps!!

View solution in original post

1 Reply
PradeepK
Creator II
Creator II

Created a calculated dimension.. 

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

disable "Include Null values" option.

 

Hope this helps!!