topic Re: How to restrict the the listbox based on condition in QlikView https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338568#M844226 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Wed, 19 Apr 2017 06:19:31 GMT prma7799 2017-04-19T06:19:31Z How to restrict the the listbox based on condition https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338565#M844219 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I want restrict the listbox items based on condition. Im attaching the sample document.</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"> <A href="https://community.qlik.com/qlik-users/23109" target="_blank">jagan</A>‌<A href="https://community.qlik.com/qlik-users/34352" target="_blank">awhitfield</A>‌<A href="https://community.qlik.com/qlik-users/15823" target="_blank">swuehl</A>‌<A href="https://community.qlik.com/qlik-users/36145" target="_blank">adamdavi3s</A>‌<A href="https://community.qlik.com/qlik-users/21667" target="_blank">cleveranjos</A>‌<A href="https://community.qlik.com/qlik-users/146743" target="_blank">manojqlik</A>‌</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338565#M844219 ashokpaladugula 2020-11-25T16:16:04Z Re: How to restrict the the listbox based on condition https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338566#M844221 <HTML><HEAD></HEAD><BODY><P>=If(not IsNull(Reason), customerName)</P></BODY></HTML> Wed, 19 Apr 2017 06:13:31 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338566#M844221 tresB 2017-04-19T06:13:31Z Re: How to restrict the the listbox based on condition https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338567#M844224 <HTML><HEAD></HEAD><BODY><P>Please try in your list box expression like below</P><P></P><P>=if( len (Reason) &lt;&gt;&nbsp; 0,customerName)</P></BODY></HTML> Wed, 19 Apr 2017 06:17:27 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338567#M844224 prma7799 2017-04-19T06:17:27Z Re: How to restrict the the listbox based on condition https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338568#M844226 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Wed, 19 Apr 2017 06:19:31 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338568#M844226 prma7799 2017-04-19T06:19:31Z Re: How to restrict the the listbox based on condition https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338569#M844228 <HTML><HEAD></HEAD><BODY><P>Or may be this too</P><P><STRONG>=If(not WildMatch(Reason,0), customerName)</STRONG></P></BODY></HTML> Wed, 19 Apr 2017 06:20:31 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338569#M844228 Anil_Babu_Samineni 2017-04-19T06:20:31Z Re: How to restrict the the listbox based on condition https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338570#M844229 <HTML><HEAD></HEAD><BODY><P>Thanks to all,</P><P>All above answers are correct and useful.</P><P></P><P>Thanks,</P><P>ASHOK</P></BODY></HTML> Wed, 19 Apr 2017 06:24:51 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338570#M844229 ashokpaladugula 2017-04-19T06:24:51Z Re: How to restrict the the listbox based on condition https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338571#M844230 <HTML><HEAD></HEAD><BODY><P>Hi Tresesco,</P><P></P><P>Listbox filter the values correctly, but in the current selections showing two filter values. so, i want show the selected customer filter in the current selection box. Please find the attachment.</P><P><IMG alt="customer filter issue.png" class="jive-image image-1" src="/legacyfs/online/165040_customer filter issue.png" style="height: 260px; width: 620px;" /></P></BODY></HTML> Mon, 29 May 2017 08:10:59 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338571#M844230 ashokpaladugula 2017-05-29T08:10:59Z Re: How to restrict the the listbox based on condition https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338572#M844231 <HTML><HEAD></HEAD><BODY><P>Well, try the below expression:</P><P></P><P><SPAN style="color: #3366ff; font-family: 'courier new', courier;">=Aggr(only({&lt;customerName,Reason={'*'}&gt;} customerName), customerName)</SPAN></P><P></P></BODY></HTML> Mon, 29 May 2017 09:07:30 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-the-the-listbox-based-on-condition/m-p/1338572#M844231 tresB 2017-05-29T09:07:30Z