topic Re: Variable Between 2 Multiboxes in QlikView

Variable Between 2 Multiboxes

Tue, 12 Mar 2013 16:10:20 GMT

I have 2 Mutli Boxes (A & B), each displaying differant data.

I need to make it so that once a selection is made in mutlibox A, that it automatically clears any selection made in multibox B.

Any suggestions on what the best way to achieve this is?

Re: Variable Between 2 Multiboxes

Tue, 12 Mar 2013 16:21:04 GMT

Hi!

Try in Multibox B..

= if(GetSelectedCount([Product 1])=0,1,0)

Re: Variable Between 2 Multiboxes

Tue, 12 Mar 2013 16:47:15 GMT

Thanks Rebeca,

This works great. However, I failed to mention that I also want this function to work in reverse. So that if I make a selection in box B then any selection in box A is cleared.

If I apply

= if(GetSelectedCount([Product 1])=0,1,0)

to both of the multi boxes and make a slection, both of the boxes appear to become locked, in that neither of their dropdown menus will apeear and I neither select or de-select any of the options

Re: Variable Between 2 Multiboxes

Tue, 12 Mar 2013 17:01:09 GMT

It would be like the attachment?

Re: Variable Between 2 Multiboxes

Tue, 12 Mar 2013 17:14:16 GMT

Rebecca,

I need the logic to clear the selections of the multi-boxes not to hide them.

Re: Variable Between 2 Multiboxes

Tue, 12 Mar 2013 17:19:21 GMT

I've kinda modified the previous approac suggested here by creating a variable say "vToggle" as;

=if(GetSelectedCount([Product 1])>0,1,if(GetSelectedCount([Product 2])>0, 2, 3))

Now the variable vTogger has 3 states;

1 = selection made in Box A

2 = selection made in Box B

3 = None selected

Based on the above you can set "Conditional Show" property on each multibox.

Hope that helps.

Regards

Vikas

Re: Variable Between 2 Multiboxes

Tue, 12 Mar 2013 17:20:14 GMT

Use a variable and set the trigger on the selection.

Re: Variable Between 2 Multiboxes

Tue, 12 Mar 2013 17:24:28 GMT

Have you tried using a trigger, which is the 'Document Property'?

Re: Variable Between 2 Multiboxes

Wed, 13 Mar 2013 09:50:20 GMT

I'm not familiar with Triggars as I am still new to Qlikview.

I've set up a trigger on Multibox 2 with the Action: Clear Field =[Multibox 1]

But it does not appear to take any action.

Is thee somewhere else in the document where I need to activate triggers on either of the mutlboxes?

Thanks again, much apreciated

Re: Variable Between 2 Multiboxes

Wed, 13 Mar 2013 10:19:14 GMT

Hello Tony,

As per my understanding this should be easily done with use of Triggers.

Navigate to Settings-> Document Properties -> Triggers.

In the Field Event Triggers, chose your Field which is used to populate Multibox A.

And on Select Trigger, Add an Event,

Selection-> Clear Field and then write the Field used in Multibox B.

Similarly do this for MultiBox B.

Let me know if this helps, or i can send you the qvw

Thanks,

itsangad