Discussion board where members can get started with QlikView.
I have 2 sheets and in sheet 1 , I have a multi box without alternate state, and in sheet 2 , I have a multi box with alternate state.
so, if user select a value Multibox obj in sheet 1 , then in sheet 2 multibox should also select same value.
if value not available in second multibox, it should select default value as 1 'Lat Amer.'
We need to implement this, please suggest..
Sheet 1 WRLD_RGN1 used for multibox
LOAD * INLINE [ WRLD_RGN1, Value1 Lat.Amer, 1 N.Amer, 2 Caribbean, 3 Africa, 4 E.Eur, 5 Europe,6 MiddleEast, 7 Oceania, 8 Supra, 9 Asia, 10 OffShore, 11 India, 12 ];
sheet 2 WRLD_RGN2 used for multibox
Region1: Region2: LOAD * INLINE [ WRLD_RGN2, Value2 Lat.Amer, 1 N.Amer, 2 Caribbean, 3 Europe,6 MiddleEast, 7 Oceania, 8 OffShore, 11 ];
You will need to use triggers and actions
on select or on change of WRLD_RGN1 add action with the alternate state Select in field for WRLD_RGN2
Yeah, in this we need to set to default when value unmatched, there I am facing issue
Please try to use below expression in the trigger search string:
=If(Match(WRLD_RGN2,GetFieldSelections(WRLD_RGN1)) > 0,WRLD_RGN1,'Lat.Amer')
What's your expression currently?
Currently I am using getfieldselections function and is working foratched case
Match case is fine, for uatch case I am working with Aiolos suggestion
Great mark and close the thread if it does work
Yes. working fine. and Thanks.