Set field value on behalf of other field

[qliklearnervir]

Hi,

I want to create a scenerio where i have 2 field ...Arrival Period Code & Booking Period Code;;;

Values are

Arrival Period Code                        Booking Period Code

P1                                                 P1

P2                                                 P2

P3                                                 P3

P4                                                 P4

P5                                                 p5

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.

Period code

P1

P2

P3

P4

P5

Is it possbie that from 1 list box ...i can select 2 filed values at a same time...

[sunny_talwar]

You sure can, you need to create a link table to do this:

LinkTable:

LOAD [Arrival Period Code] as [Period Code],

          [Arrival Period Code],

          'Arrival' as Flag

Resident Table;

Concatenate (LinkTable)

LOAD [Booking Period Code] as [Period Code],

          [Booking Period Code],

          'Booking' as Flag

Resident Table;

[tresesco]

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.

[Kushal_Chawda]

Another way is create the inline table and use field event triggers to select the values in both the field

PeriodCode:

LOAD * inline [

PeriodCode

P1

P2

P3

P4

P5 ];

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

[qliklearnervir]

Hi Kushal,

Can you please explain more on this trigger............

[Kushal_Chawda]

see the last post in this link

field event trigger, deselection to deselect an... | Qlik Community

[tresesco]

PFA