Get the excluded values from a list box.

[#1]

Hi guys,

I have two list box... ListBox A and B...

The values of List box A and B are the same.. ListBox A. ListBox B

value1 value1

value2 value2

value3 value3

but I want to Select a value in List Box A and the ListBox B will displayed the other values that not selected.

If I select Value1 in ListBox A...List box B must display Value2 and Value3

Is this possible?

Im new in QlikView. Thanks for the help.

[#2 · Accepted solution]

A macro like this should do it:

[martin59]

Hi,

Your both fields are in the same table ?

[#4]

@Jesper.. thanks for the reply..

I'm totally new in Qlikview and I don't know where to put those codes.. . btw I'm using version 9.0

[#5]

@Martin - No..it's in separate tables. Thanks

[#6]

Hi Jesper

I figured it out.. I need to set in actions to run a macro... and your code works!

thanks for helping mo out!