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: 
17George
Contributor II
Contributor II

triger select a range of values

Hello,
I need you help with an "OnOpen" trigger with "Select In Field" action on the Year values
How to select the last 5 years?
The syntax of the search string should be like " > (max(Year) - 5)" and the result like in the picture below

year-box.jpg

Labels (2)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

Perhaps for the search string expression.

='>=' & (max(Year)-5)

View solution in original post

1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Perhaps for the search string expression.

='>=' & (max(Year)-5)