Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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)