Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
khan_fayez
Creator
Creator

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

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.

1 Solution

Accepted Solutions
sunny_talwar

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

Capture.PNG

View solution in original post

15 Replies
sunny_talwar

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

miguelbraga
Specialist III
Specialist III

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

khan_fayez
Creator
Creator
Author

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.

khan_fayez
Creator
Creator
Author

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
Specialist
Specialist

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

khan_fayez
Creator
Creator
Author

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)

khan_fayez
Creator
Creator
Author

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

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

Capture.PNG

View solution in original post

khan_fayez
Creator
Creator
Author

Yes. This is what I am looking for