topic Re: how to limit the list box fields ? in QlikView https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254580#M863782 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>another solution might be:</P><P></P><P><IMG alt="QlikCommunity_Thread_244810_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148034_QlikCommunity_Thread_244810_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 30 Dec 2016 23:48:43 GMT MarcoWedel 2016-12-30T23:48:43Z how to limit the list box fields ? https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254577#M863779 <HTML><HEAD></HEAD><BODY><P>i have a list box with Open closed and uninstalled fields</P><P>but i need only open and closed ?</P><P></P><P>how to get this in presentation chart properties (front end) not script wise</P><P><IMG alt="Screenshot_5.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148000_Screenshot_5.png" style="height: auto;" /></P><P></P><P>thanks,</P><P>Muthu</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254577#M863779 2020-11-25T16:16:04Z Re: how to limit the list box fields ? https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254578#M863780 <HTML><HEAD></HEAD><BODY><P>Try this? <IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148015_Capture.PNG" style="height: 354px; width: 620px;" /></P></BODY></HTML> Fri, 30 Dec 2016 18:37:58 GMT https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254578#M863780 vishsaggi 2016-12-30T18:37:58Z Re: how to limit the list box fields ? https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254579#M863781 <HTML><HEAD></HEAD><BODY><P>Use this expression to create list box..</P><P>=IF(Match(UPPER(YourFieldName),'OPEN','CLOSED'),YourFieldName)</P></BODY></HTML> Fri, 30 Dec 2016 18:45:23 GMT https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254579#M863781 MK_QSL 2016-12-30T18:45:23Z Re: how to limit the list box fields ? https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254580#M863782 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>another solution might be:</P><P></P><P><IMG alt="QlikCommunity_Thread_244810_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148034_QlikCommunity_Thread_244810_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 30 Dec 2016 23:48:43 GMT https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254580#M863782 MarcoWedel 2016-12-30T23:48:43Z Re: how to limit the list box fields ? https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254581#M863783 <HTML><HEAD></HEAD><BODY><P>Thank you so much, Marco it is very use full for me</P><P></P><P>can we able to get this without using set analysis</P></BODY></HTML> Mon, 02 Jan 2017 12:25:14 GMT https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254581#M863783 2017-01-02T12:25:14Z Re: how to limit the list box fields ? https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254582#M863784 <HTML><HEAD></HEAD><BODY><P>Well, I think Manish Kachhia's solution might be what you're looking for.</P><P>But why would you like to avoid set analysis at all?</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 02 Jan 2017 23:53:16 GMT https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254582#M863784 MarcoWedel 2017-01-02T23:53:16Z Re: how to limit the list box fields ? https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254583#M863785 <HTML><HEAD></HEAD><BODY><P>no i thought it would be help full for different scenarios </P><P></P><P></P><P>any way thank you </P><P></P><P></P><P>Muthu</P></BODY></HTML> Thu, 12 Jan 2017 20:03:56 GMT https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254583#M863785 2017-01-12T20:03:56Z Re: how to limit the list box fields ? https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254584#M863786 <HTML><HEAD></HEAD><BODY><P>you're welcome.</P><P></P><P>Please close your thread if your question is answered:</P><P></P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 12 Jan 2017 22:59:13 GMT https://community.qlik.com/t5/QlikView/how-to-limit-the-list-box-fields/m-p/1254584#M863786 MarcoWedel 2017-01-12T22:59:13Z