Variable Between 2 Multiboxes

[#1]

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?

[#2]

Hi!

Try in Multibox B..

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

[#3]

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

[#4]

It would be like the attachment?

[#5]

Rebecca,

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

[#6]

Hi

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

[#7]

Use a variable and set the trigger on the selection.

[#8]

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

[#9]

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

[#10]

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