Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

need to show all the values in listbox 2 minus the value that is selected in List box 1

I  need to show all the values in LB2 minus the value that is selected in LB1. e..g LB1 has A,B,C,D as values and LB2 has same values.

When I select A in LB1 , LB2 should list only B,C,D

1 Reply
MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_235178_Pic1.JPG

QlikCommunity_Thread_235178_Pic2.JPG

QlikCommunity_Thread_235178_Pic3.JPG

QlikCommunity_Thread_235178_Pic4.JPG

=Aggr(If(GetSelectedCount(value),Only({1-$} value),Only(value)),value)

hope this helps

regards

Marco