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

Field Event Triggers - List boxes

Hi,

Simple question I hope.

I have two list boxes:

1. Menu

2. Snapshot date

When the value '6' is selected in the Menu list box, I want to show the max value in the Snapshot date list box.

Finally, if  the Menu value is changed from 6, then clear that max value in the snapshot date list box. 

Is this achievable? 

I think this can be achieved by a trigger but I don't know where to begin. 

Please help

Many thanks,

Rob

Labels (3)
1 Solution

Accepted Solutions
R0b
Contributor II
Contributor II
Author

Solved my own issue. 

Need to assign an 'On Select' field event trigger to my list box field.

Under actions, choose 'Select In Field'.

In the field, write the name of your field like this: Date Snapshot

and then in my search string I have: =IF(%_Menu_Wlist='Details',vMaxSnapshotDate,'')

That way, when I click on 'Details' in my listbox, it will make my date snapshot the equivalent to my variable (max date).

Hope this helps someone in the future!

 

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

you need to use field  event triggers OnChange and use select infield

check below video to give you an overview

https://www.youtube.com/watch?v=9vKN4-FgXZE

R0b
Contributor II
Contributor II
Author

Solved my own issue. 

Need to assign an 'On Select' field event trigger to my list box field.

Under actions, choose 'Select In Field'.

In the field, write the name of your field like this: Date Snapshot

and then in my search string I have: =IF(%_Menu_Wlist='Details',vMaxSnapshotDate,'')

That way, when I click on 'Details' in my listbox, it will make my date snapshot the equivalent to my variable (max date).

Hope this helps someone in the future!