Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Created a calculated dimension..
Aggr(
Only({< Name = {"= Rank(Created,4)<=5 "} >}Name)
,Name)
disable "Include Null values" option.
Hope this helps!!
Created a calculated dimension..
Aggr(
Only({< Name = {"= Rank(Created,4)<=5 "} >}Name)
,Name)
disable "Include Null values" option.
Hope this helps!!