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: 
aatish12345
Creator II
Creator II

Selecting Latest 2 years from Year filter using sheet level action

Hi All,

I have an Year filter consisting of below data:

 

2020

2019

2018

 

When I am jumping on the sheet I want latest 2 years(2020 and 2019) to be selected by default using action.

Can someone please help!

 

Aatish

Labels (1)
1 Reply
Or
MVP
MVP

Try something along the lines of the search string:

=Year>=Max(ALL Year,2)