Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
This is probably not possible or not relevant, but can it work the other way around meaning if someone clicks something in Group2 first?
Use the below in the 1st list box
=Aggr(If(GetSelectedCount(ProductName, False(),'Group2') = 0, ProductName, Only({1<ProductName = e({Group2} ProductName)>} ProductName)), ProductName)
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)
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