topic need to show all the values in listbox 2 minus the value that is selected in List box 1 in QlikView https://community.qlik.com/t5/QlikView/need-to-show-all-the-values-in-listbox-2-minus-the-value-that-is/m-p/1200840#M880527 <HTML><HEAD></HEAD><BODY><P>I&nbsp; 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.</P><P>When I select A in LB1 , LB2 should list only B,C,D</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z need to show all the values in listbox 2 minus the value that is selected in List box 1 https://community.qlik.com/t5/QlikView/need-to-show-all-the-values-in-listbox-2-minus-the-value-that-is/m-p/1200840#M880527 <HTML><HEAD></HEAD><BODY><P>I&nbsp; 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.</P><P>When I select A in LB1 , LB2 should list only B,C,D</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/need-to-show-all-the-values-in-listbox-2-minus-the-value-that-is/m-p/1200840#M880527 Anonymous 2020-11-25T16:16:04Z Re: need to show all the values in listbox 2 minus the value that is selected in List box 1 https://community.qlik.com/t5/QlikView/need-to-show-all-the-values-in-listbox-2-minus-the-value-that-is/m-p/1200841#M880528 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution could be:</P><P></P><P><IMG alt="QlikCommunity_Thread_235178_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139616_QlikCommunity_Thread_235178_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><P><IMG alt="QlikCommunity_Thread_235178_Pic2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/139617_QlikCommunity_Thread_235178_Pic2.JPG" style="max-width: 620px; height: auto;" /></P><P></P><P><IMG alt="QlikCommunity_Thread_235178_Pic3.JPG" class="image-5 jive-image" src="https://community.qlik.com/legacyfs/online/139620_QlikCommunity_Thread_235178_Pic3.JPG" style="height: auto; width: auto;" /></P><P></P><P><IMG alt="QlikCommunity_Thread_235178_Pic4.JPG" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/139619_QlikCommunity_Thread_235178_Pic4.JPG" style="height: 310px; width: 620px;" /></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14756152971056761" jivemacro_uid="_14756152971056761"> <P>=Aggr(If(GetSelectedCount(value),Only({1-$} value),Only(value)),value)</P> </PRE><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Tue, 04 Oct 2016 21:12:25 GMT https://community.qlik.com/t5/QlikView/need-to-show-all-the-values-in-listbox-2-minus-the-value-that-is/m-p/1200841#M880528 MarcoWedel 2016-10-04T21:12:25Z