Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
See why Qlik was recognized for the seventh year in a row – and discover how we can help you tackle your data integration challenges. Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

activate sheet based on selection in multibox.

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?

1 Solution

Accepted Solutions
Not applicable
Author

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!

View solution in original post

8 Replies
Not applicable
Author

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!

Not applicable
Author

Hi,

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

Regards,

Nirmal.

Not applicable
Author

hi...

lironbaram
Partner - Master III
Partner - Master III

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

vikasmahajan

Hii

PFA

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
tresesco
MVP
MVP

PFA. Using a trigger.

Not applicable
Author

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'

thomas_skariah
Creator III
Creator III

Hi Kausalya,

Try this.

Regards,

Tom