Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thimma_paul
Contributor III
Contributor III

Sheet Navigation , Alternate state issue

Hi,

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
]
;

8 Replies
dplr-rn
Partner - Master III
Partner - Master III

You will need to use triggers and actions

e.g.

on select or on change of WRLD_RGN1 add action with the alternate state Select in field for WRLD_RGN2


thimma_paul
Contributor III
Contributor III
Author

Yeah, in this we need to set to default when value unmatched, there I am facing issue

uacg0009
Partner - Specialist
Partner - Specialist

Hi Thimma,

Please try to use below expression in the trigger search string:

=If(Match(WRLD_RGN2,GetFieldSelections(WRLD_RGN1)) > 0,WRLD_RGN1,'Lat.Amer')

Aiolos

dplr-rn
Partner - Master III
Partner - Master III

What's your expression currently?

thimma_paul
Contributor III
Contributor III
Author

Currently I am using getfieldselections function and is working foratched case

thimma_paul
Contributor III
Contributor III
Author

Match case is fine, for uatch case I am working with Aiolos suggestion

dplr-rn
Partner - Master III
Partner - Master III

Great mark and close the thread if it does work

thimma_paul
Contributor III
Contributor III
Author

Yes. working fine. and Thanks.