Disable a value in different list box on selecting the same value in another listbox

[Anonymous]

Hi all,

My requirement is that I have 2 list boxes showing same fields. e.g. List Box 1: A,B,C,D,E. & List Box 2: A,B,C,D,E. So when I select A in List Box 1, the 'A' in listbox2 should get hidden or greyed out. Basically I have to do comparison  of A vs B or A vs C or B vs C.

If the value that has been selected in ListBox1 is not disabled than user can select the same A from ListBox2 which does not make sense.

[sunny_talwar]

Would you be able to share a sample to see how the two list boxes are related?

[miguelbraga]

Hey there,

Can you please send us your data model and/or a qvw and/or a Excel file with the values of the two list boxes? With your given information it's hard to help you.

Best regards,

D.A. MB

[Anonymous]

Thanks Sunny. Cant attach the file. Firm policy.  I have pasted the screen shot. So what I need is when I select A in LB1, the A in LB2 should get hidden or greyed out. Both the list boxes use the same field or column as source.

[Anonymous]

Thanks Miguel. Cant attach the file. Firm policy.  I have pasted the screen shot. So what I need is when I select A in LB1, the A in LB2 should get hidden or greyed out. Both the list boxes use the same field or column as source.

[rupamjyotidas]

Maybe you can do something with 'Alternate State'.

Although I don't have a example for the same. Other folks might be able to give an example

[Anonymous]

I need to show all the values in LB2 minus the value that is selected in LB1. I tried using this expression but somehow it is not working

=only({<ID2={'*'}-{"=GetFieldSelections(ID1)"}>}ID2)

[Anonymous]

Hi Sunny, I have pasted the snapshot. The 2nd column will not be Baseline rather it will be the 2nd field selected in Scenario. Third field will ne be difference of 2.

[sunny_talwar · Accepted solution]

Can you check if this is something what you are looking for?

[Anonymous]

Yes. This is what I am looking for