Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

thimma_paul
New 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
dilipranjith
Valued Contributor II

Re: Sheet Navigation , Alternate state issue

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
New Contributor III

Re: Sheet Navigation , Alternate state issue

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

uacg0009
Valued Contributor

Re: Sheet Navigation , Alternate state issue

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

dilipranjith
Valued Contributor II

Re: Sheet Navigation , Alternate state issue

What's your expression currently?

thimma_paul
New Contributor III

Re: Sheet Navigation , Alternate state issue

Currently I am using getfieldselections function and is working foratched case

thimma_paul
New Contributor III

Re: Sheet Navigation , Alternate state issue

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

dilipranjith
Valued Contributor II

Re: Sheet Navigation , Alternate state issue

Great mark and close the thread if it does work

thimma_paul
New Contributor III

Re: Sheet Navigation , Alternate state issue

Yes. working fine. and Thanks.

Community Browser