Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
suppose if the user select the millions from UNIT list box the same value has to be selected in UNIT1..how to do this
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
Hi Manorajan,
See attached, see field actions.
Regards!
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