Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
khan_fayez
Creator
Creator

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