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

Two List Box

I have two list box  value of millions billions and thousands but both are different line line table

Inline_Dimension:

LOAD * INLINE [

UNIT

Billion,

Thousands,

Millions

];

Inline_Dimension2:

LOAD * INLINE [

UNIT1

Billion,

Thousands,

Millions

];

suppose if the user select the UNIT list box the same have to be selected in UNIT1 list box how to acheive this

4 Replies
manoranjan_d
Specialist
Specialist
Author

suppose if the user select the millions from UNIT list box the same value has to be selected in UNIT1..how to do this

avinashelite

you could try with Triggers in Qlikview, go to document properties > Triggers > select the field i.e. UNIT and set the OnSelect trigger with the field values as UNIT1 and search string with the field selection of UNIT (you could use getfieldselection() function

Anonymous
Not applicable

Hi Manorajan,

See attached, see field actions.

Regards!

its_anandrjs

You can create another synthetic table for creating same field name

Ex:-

Inline_Dimension:

LOAD * INLINE [

UNIT

Billion,

Thousands,

Millions

];

Inline_Dimension2:

LOAD * INLINE [

UNIT1

Billion,

Thousands,

Millions

];

SynTable:

LOAD UNIT AS UN,

UNIT

Resident Inline_Dimension;

Concatenate(SynTable)

LOAD UNIT1 as UN,

UNIT1

Resident Inline_Dimension2;

Then on the front end use UN field for make selection in both the fields.

Regards

Anand