Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
matthewp
Creator III
Creator III

select last 3 years in default selection using trigger

i On activate sheet select in field

Field

iyear

Search String

= year(Today())-2

This selects 2013 only

I want to select 2013, 2014 & 2015 (the last 3 years including current)

1 Solution

Accepted Solutions
Not applicable

try the synthase below

= '>= ' & $(=year(Today())-2)

View solution in original post

1 Reply
Not applicable

try the synthase below

= '>= ' & $(=year(Today())-2)