How do I exclude values from a List Box using Alternate States?

[cliff_clayman]

I have two list boxes with the same dimension.  When I make a selection in the first list box, I do not want that same value available for selection in the second list box.  How can I do this?

[cliff_clayman]

This is probably not possible or not relevant, but can it work the other way around meaning if someone clicks something in Group2 first?

[#3]

Use the below in the 1st list box

=Aggr(If(GetSelectedCount(ProductName, False(),'Group2') = 0, ProductName, Only({1<ProductName = e({Group2} ProductName)>} ProductName)), ProductName)

[sunny_talwar]

Unable to test this because I have QV11 SR5 installed on my machine at work, but try this out

=Aggr(If(GetSelectedCount(ProductName, False(),'Group2') = 0, ProductName, Only({1<ProductName = e({Group2} ProductName)>} ProductName)), ProductName)

[sunny_talwar]

Actually, when I tested, I saw a slight loophole in the expression.

Try these:

=Aggr(If(GetSelectedCount(ProductName, False(),'Group2') = 0, Only({1} ProductName), Only({1<ProductName = e({Group2} ProductName)>} ProductName)), ProductName)

=Aggr(If(GetSelectedCount(ProductName, False(),'Group1') = 0, Only({1} ProductName), Only({1<ProductName = e({Group1} ProductName)>} ProductName)), ProductName)

Attached the updated qvw with this email.

Best,

Sunny