topic Field Event Triggers - List boxes in QlikView

Field Event Triggers - List boxes

R0b — Sat, 16 Nov 2024 00:09:54 GMT

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

dplr-rn — Tue, 11 Aug 2020 15:25:13 GMT

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

check below video to give you an overview

R0b — Wed, 12 Aug 2020 11:36:31 GMT

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!