to show Top 5 Year in filterpane

[Qlik1_User1]

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

[fosuzuki · Accepted solution]

Hi

Try this:

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

Hope this helps

[Qlik1_User1]

Thanks it worked..