Discussion Board for collaboration on QlikView Scripting.
I want to create a scenerio where i have 2 field ...Arrival Period Code & Booking Period Code;;;
Arrival Period Code Booking Period Code
As per my requirement i want to set an value for Arrival Period Code and same value for Booking Period Code.
and list box should be one.
Is it possbie that from 1 list box ...i can select 2 filed values at a same time...
You sure can, you need to create a link table to do this:
LOAD [Arrival Period Code] as [Period Code],
[Arrival Period Code],
'Arrival' as Flag
LOAD [Booking Period Code] as [Period Code],
[Booking Period Code],
'Booking' as Flag
You can user trigger to do so or create a new link table in the script. All depend on how your data model is. Try to share your sample qvw.
Another way is create the inline table and use field event triggers to select the values in both the field
LOAD * inline [
Now when you select any value , you set the Field event trigger on field PeriodCode to select the values in field Arrival period code and Book period code
Can you please explain more on this trigger............
see the last post in this link
field event trigger, deselection to deselect an... | Qlik Community