topic Re: Disable a value in different list box on selecting the same value in another listbox in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

sunny_talwar — Tue, 04 Oct 2016 13:19:33 GMT

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

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

miguelbraga — Tue, 04 Oct 2016 13:32:05 GMT

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

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

Anonymous — Tue, 04 Oct 2016 13:52:07 GMT

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.

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

Anonymous — Tue, 04 Oct 2016 13:53:06 GMT

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.

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

rupamjyotidas — Tue, 04 Oct 2016 14:49:31 GMT

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

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

Anonymous — Tue, 04 Oct 2016 15:37:58 GMT

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)

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

Anonymous — Tue, 04 Oct 2016 18:47:52 GMT

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.

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

sunny_talwar — Tue, 04 Oct 2016 18:57:12 GMT

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

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

Anonymous — Tue, 04 Oct 2016 19:11:00 GMT

Yes. This is what I am looking for

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

MarcoWedel — Tue, 04 Oct 2016 22:39:44 GMT

Hi,

is this the same requirement as in your thread need to show all the values in listbox 2 minus the value that is selected in List box 1

regards

Marco

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

Anonymous — Wed, 05 Oct 2016 11:00:19 GMT

Thanks a lot Sunny. Just one question. I don't understand why to we use aggr here. If you can please explain it to me it will be very helpful.

=Aggr(If(GetSelectedCount(Scenario) = 0, Only(Compare_Scenario), Only({<Compare_Scenario = e(Scenario)>} Compare_Scenario)), Compare_Scenario).

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

Anonymous — Wed, 05 Oct 2016 11:01:41 GMT

Yes it is the same one.

Thanks for your reply. That works too but in my context that will be a bit difficult to implement.

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

rajpreeths — Wed, 05 Oct 2016 11:38:06 GMT

Hi,

Sunny stalwar1‌ has done it in awesome way!!!

Aggr function has been used here just to aggregate appropriate values in the second list box as per your requirement.

If no value is selected in Scenario (GetSelectedCount(Scenario) = 0) , the only values (Values corresponding to Compare_Scenario [all values ]->> ie. Only(Compare_Scenario) ) of Compare_Scenario will be populated in Compare_Scenario list box else the values excluded in Scenario list box will get populated in Compare_Scenario list box

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

sunny_talwar — Wed, 05 Oct 2016 12:48:31 GMT

The reason I had to use Aggr() here was because I wanted to use set analysis

=Aggr(If(GetSelectedCount(Scenario) = 0, Only(Compare_Scenario), Only({<Compare_Scenario = e(Scenario)>}Compare_Scenario)), Compare_Scenario)

The problem is that I cannot use set analysis without some kind of aggregation functions (Sum, Only, Min, Max, Median, Avg.....) and if I use any of them in my dimension, I need to use Aggr() function. So anytime you have to use set analysis in your dimension for any reason, remember to use Aggr() function.

Does that helps?

Best,

Sunny

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

MarcoWedel — Wed, 05 Oct 2016 21:33:36 GMT

you're welcome.

Glad it helped.

maybe you can close your other thread as well then:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco