topic Re: Two List Box in QlikView

Two List Box

manoranjan_d — Tue, 16 Aug 2016 12:32:11 GMT

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

Re: Two List Box

manoranjan_d — Tue, 16 Aug 2016 12:33:08 GMT

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

Re: Two List Box

avinashelite — Tue, 16 Aug 2016 12:36:54 GMT

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

Re: Two List Box

Anonymous — Tue, 16 Aug 2016 12:40:25 GMT

Hi Manorajan,

See attached, see field actions.

Regards!

Re: Two List Box

its_anandrjs — Tue, 16 Aug 2016 12:44:57 GMT

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