Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

to show Top 5 Year in filterpane

Hi All,

Can we show Top 5 Year in filter pane with use of set analysis or any other approach, except making changes in script.

Let say Field name is Year with values 2017,2018,2019,2020,2021,20122,2023

Expected Output: in Filter pane.

2019,2020,2021,20122,2023

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi

Try this:

=aggr(If(Only({1} Year)>=$(=Max({1} Year))-5,Only({1} Year)), Year)

 

Hope this helps

View solution in original post

2 Replies
Highlighted
Partner
Partner

Hi

Try this:

=aggr(If(Only({1} Year)>=$(=Max({1} Year))-5,Only({1} Year)), Year)

 

Hope this helps

View solution in original post

Highlighted
Creator III
Creator III

Thanks it worked..