Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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

manucamon
Specialist III
Specialist III

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