topic list box only with several data in QlikView https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414458#M154185 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a list box that contains the status for every invoice I have:</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>invoice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; €</STRONG></SPAN></P><P><SPAN style="text-decoration: underline;"><STRONG><BR /></STRONG></SPAN></P><P>PV001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>PV002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>PV003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05</P><P>PV004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05</P><P>PV005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06</P><P>PV006&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08</P><P></P><P>I want a list box only with codes 10 and 05 the rest I don't want to be in the list code!</P><P></P><P>Thank's</P><P></P><P>Eduard</P></BODY></HTML> Tue, 02 Apr 2013 13:49:44 GMT ecabanas 2013-04-02T13:49:44Z list box only with several data https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414458#M154185 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a list box that contains the status for every invoice I have:</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>invoice&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; status&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; €</STRONG></SPAN></P><P><SPAN style="text-decoration: underline;"><STRONG><BR /></STRONG></SPAN></P><P>PV001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>PV002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>PV003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05</P><P>PV004&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05</P><P>PV005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 99&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 06</P><P>PV006&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08</P><P></P><P>I want a list box only with codes 10 and 05 the rest I don't want to be in the list code!</P><P></P><P>Thank's</P><P></P><P>Eduard</P></BODY></HTML> Tue, 02 Apr 2013 13:49:44 GMT https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414458#M154185 ecabanas 2013-04-02T13:49:44Z Re: list box only with several data https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414459#M154186 <HTML><HEAD></HEAD><BODY><P>Use an expression for your listbox: =if(status='10' or status='05',status)</P></BODY></HTML> Tue, 02 Apr 2013 13:52:25 GMT https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414459#M154186 Gysbert_Wassenaar 2013-04-02T13:52:25Z Re: list box only with several data https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414460#M154187 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>You can create an expression from the list, as below:</P><P></P><P>=if( <STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;"><SPAN><SPAN>€</SPAN></SPAN></STRONG>= 10 or <STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;">€</STRONG> = 5,<STRONG style="background-color: #ffffff; color: #737373; font-family: Arial;">€</STRONG>)</P><P></P><P>By Rebeca</P></BODY></HTML> Tue, 02 Apr 2013 13:54:54 GMT https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414460#M154187 2013-04-02T13:54:54Z Re: list box only with several data https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414461#M154188 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>He wants the field '€' and not the 'status'.</P><P></P><P><span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P></P><P>By Rebeca</P></BODY></HTML> Tue, 02 Apr 2013 13:56:51 GMT https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414461#M154188 2013-04-02T13:56:51Z Re: list box only with several data https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414462#M154189 <HTML><HEAD></HEAD><BODY><P>thank's Gysbert!!!</P></BODY></HTML> Tue, 02 Apr 2013 14:28:19 GMT https://community.qlik.com/t5/QlikView/list-box-only-with-several-data/m-p/414462#M154189 ecabanas 2013-04-02T14:28:19Z