topic [ASK] how to make an activate multi box in QlikView

[ASK] how to make an activate multi box

Fri, 18 Feb 2011 05:09:19 GMT

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...

[ASK] how to make an activate multi box

tresB — Fri, 18 Feb 2011 05:30:28 GMT

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

Regards, tresesco

[ASK] how to make an activate multi box

Fri, 18 Feb 2011 06:06:57 GMT

@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..

[ASK] how to make an activate multi box

tresB — Fri, 18 Feb 2011 06:41:50 GMT

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.

[ASK] how to make an activate multi box

Fri, 18 Feb 2011 08:01:04 GMT

@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..

[ASK] how to make an activate multi box

tresB — Fri, 18 Feb 2011 08:15:10 GMT

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.

[ASK] how to make an activate multi box

deepakk — Fri, 18 Feb 2011 08:36:00 GMT

hi richardo,

I hope the attach application helps.

[ASK] how to make an activate multi box

Fri, 18 Feb 2011 10:08:44 GMT

@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..

[ASK] how to make an activate multi box

tresB — Fri, 18 Feb 2011 10:14:53 GMT

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

[ASK] how to make an activate multi box

Fri, 18 Feb 2011 10:15:39 GMT

@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..

[ASK] how to make an activate multi box

deepakk — Fri, 18 Feb 2011 10:19:30 GMT

hi richardo,

When you press CTr +M then you will see the macro code. This code is been triggen onSelect Event of The Field Area. ( DOcument Properties-->Trigger--> FieldEvent trigger.

how the code works...

set doc = ActiveDocument // initializing the variable

set mySelections = doc.fields("Area").GetSelectedValues // Get the Values of the selected field

if mySelections.count =1 then // check if there is only one selection

ActiveDocument.Sheets(mySelections.item(0).text).Activate // Activate the sheet.. here name of the sheet and the value of the field should be same.

end if

I hope this helps.