topic Re: activate sheet based on selection in multibox. in QlikView

activate sheet based on selection in multibox.

Mon, 16 Sep 2013 05:23:15 GMT

I had a muti box conenction with values (postpaid, prepaid).

On the selection of 'prepaid', sheet1 should be activated and on selection of 'postpaid' sheet 2 should be activated.

can anyone suggest me how can i achieve this?

Re: activate sheet based on selection in multibox.

Mon, 16 Sep 2013 05:41:04 GMT

Hi,

You can achieve this by writing field Event triggers.

Go to Properties-Document Settings-Triggers-Field Event Triggers.

Then on The required field add an action :

Action Type : Layout

Action : Activate Sheet

Here give the sheet id which you want to activate.

Hope this helps!

Re: activate sheet based on selection in multibox.

Mon, 16 Sep 2013 05:44:17 GMT

Hi,

PFA......... Hope it is helpful for you.........

Regards,

Nirmal.

Re: activate sheet based on selection in multibox.

Mon, 16 Sep 2013 05:49:39 GMT

hi...

Re: activate sheet based on selection in multibox.

lironbaram — Mon, 16 Sep 2013 06:00:26 GMT

go to sheet1 then right click the mouse and select properties

then in the general tab , in the show sheet select conditional

in the condition box insert match(getfieldselections(Field1),'postpaid')>0

where Field1 is the field in your multibox

for sheet 2 insert the condition match(getfieldselections(Field1),'postpaid')>0

Re: activate sheet based on selection in multibox.

vikasmahajan — Mon, 16 Sep 2013 06:06:31 GMT

Hii

PFA

Re: activate sheet based on selection in multibox.

tresB — Mon, 16 Sep 2013 06:17:13 GMT

PFA. Using a trigger.

Re: activate sheet based on selection in multibox.

Mon, 16 Sep 2013 06:26:21 GMT

Hi,

Go to the Sheet1 properties->General->Conditional->In expression write =values='prepaid'

Go to the Sheet2 properties->General->Conditional->In expression write =values='postpaid'

Re: activate sheet based on selection in multibox.

thomas_skariah — Mon, 16 Sep 2013 07:05:55 GMT

Hi Kausalya,

Try this.

Regards,

Tom