Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

[ASK] how to make an activate multi box

hello...

i wanna ask a question

i have a multibox with a field called "Area"

can i make this multibox to activate sheet?

example, when i click Area n choose Tokyo, then Tokyo Sheet will automatically activated and also i go to Tokyo Sheet automatically

how to do that?

please help..

many regards

thx...

1 Solution

Accepted Solutions
MVP
MVP

[ASK] how to make an activate multi box

Coming back to Trigger:

Field Event Triggers -> On Select-> Action Type (Layout) -> Action (Activate Sheet) - > Sheet ID = If (Area='Tokyo', 'SH02')

SH02 - is your sheet ID of taregt sheet.

10 Replies
MVP
MVP

[ASK] how to make an activate multi box

Try using Trigger, it would allow you do what you want. Try something like "OnSelect" event under 'Field Event Triggers'.

Regards, tresesco

Not applicable

[ASK] how to make an activate multi box

@tresesco

hello Tres...

i've tried what u suggested

sheet properties -> triggers -> choose object -> add triggers on activate

and i choose action "Toogle Select" with

1. field =Area

2. search string 'Tokyo'

but nothing is happening

more help please..

many thx..

MVP
MVP

[ASK] how to make an activate multi box

Hi, i think i misunderstood your requirement. you can do it in an easier manner. use conditional display property of sheet ( General tab -> Show Sheet -> Conditional), put there, Area='Tokyo'. it is done. if it doest help, please let me know.

Not applicable

[ASK] how to make an activate multi box

@tresesco

helo Tres..

that's one of a great idea

but what client want is that when i choose Tokyo, the Tokyo sheet will open and the sheet will go to Tokyo sheet without user have to click Tokyo sheet

just a lil bit more help please

many thx..

MVP
MVP

[ASK] how to make an activate multi box

Coming back to Trigger:

Field Event Triggers -> On Select-> Action Type (Layout) -> Action (Activate Sheet) - > Sheet ID = If (Area='Tokyo', 'SH02')

SH02 - is your sheet ID of taregt sheet.

Highlighted
deepakk
Valued Contributor III

[ASK] how to make an activate multi box

hi richardo,

I hope the attach application helps.

Not applicable

[ASK] how to make an activate multi box

@tresesco

where is the menu Field Event Triggers?

because i can't fing "On Select" selection

@Deepak Kurup

great one Pak..

can u tell me how?

because i don't know what to do when i see ur solution

many tx to both of u..



MVP
MVP

[ASK] how to make an activate multi box

Settings -> Document properties -> Triggers and there you would find it.

Not applicable

[ASK] how to make an activate multi box

@tresesco

solved

i know ur solution

many thx tresesco..

@Deepak Kurup

solved also

u use macro, right?

i'm know nothing about it

but it also a great one

many thx Pak..