Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!!