Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qliklearnervir
Creator
Creator

Set field value on behalf of other field

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...

6 Replies
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
MVP
MVP

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
Creator
Creator
Author

Hi Kushal,

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

tresesco
MVP
MVP

PFA