topic Re: Sheet Navigation , Alternate state issue in QlikView

Sheet Navigation , Alternate state issue

thimma_paul — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Sheet Navigation , Alternate state issue

dplr-rn — Tue, 09 Oct 2018 17:59:33 GMT

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

Re: Sheet Navigation , Alternate state issue

thimma_paul — Wed, 10 Oct 2018 03:26:43 GMT

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

Re: Sheet Navigation , Alternate state issue

uacg0009 — Wed, 10 Oct 2018 07:35:20 GMT

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

Re: Sheet Navigation , Alternate state issue

dplr-rn — Wed, 10 Oct 2018 11:23:29 GMT

What's your expression currently?

Re: Sheet Navigation , Alternate state issue

thimma_paul — Wed, 10 Oct 2018 11:44:41 GMT

Currently I am using getfieldselections function and is working foratched case

Re: Sheet Navigation , Alternate state issue

thimma_paul — Wed, 10 Oct 2018 11:45:26 GMT

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

Re: Sheet Navigation , Alternate state issue

dplr-rn — Wed, 10 Oct 2018 11:46:52 GMT

Great mark and close the thread if it does work

Re: Sheet Navigation , Alternate state issue

thimma_paul — Thu, 11 Oct 2018 17:37:18 GMT

Yes. working fine. and Thanks.