topic Re: Limited records in List box in QlikView https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081473#M919533 <HTML><HEAD></HEAD><BODY><P>The best thing is to filter out the needed countries in the script as a separate field. The other option is you can use below in the List box -expression:</P><P></P><P></P><P>=if( mixmatch([Country], 'SRI Lu ANKA','UNITED KINGDOM','IRELAND','TANZANIA','INDIA'), [Country])</P></BODY></HTML> Thu, 05 May 2016 11:38:24 GMT trdandamudi 2016-05-05T11:38:24Z Limited records in List box https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081467#M919527 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How to show some of few records in to the list box .</P><P></P><P>For Ex:</P><P></P><P>The below counties are present in my list box as <STRONG> Country</STRONG></P><P></P><P></P><P>MAURITIUS</P><P>SWEDON</P><P>USA</P><P>NEW ZEALAND</P><P>SOUTH AFRICA</P><P>NAMIBIA</P><P>IVORY COAST</P><P>THAILAND</P><P>UGANDA</P><P>CANADA</P><P>MYANMAR</P><P>KENYA</P><P>SRI LANKA</P><P>MALAYSIA</P><P>GREECE</P><P>CROATIA</P><P>NETHERLAND</P><P>AUSTRALIA</P><P>UNITED KINGDOM</P><P>CHILE</P><P>IRELAND</P><P>UKRAINE</P><P>BOLIVIA</P><P>TANZANIA</P><P>YEMEN</P><P>INDIA</P><P>GERMANY</P><P></P><P></P><P></P><P>But I want to show only few like below </P><P></P><P>SRI LANKA</P><P>UNITED KINGDOM</P><P>IRELAND</P><P>TANZANIA</P><P>INDIA</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081467#M919527 prma7799 2020-11-25T16:16:04Z Re: Limited records in List box https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081468#M919528 <HTML><HEAD></HEAD><BODY><P>create a bookmark ..and apply that bookmark </P><P></P><P>orelse&nbsp;&nbsp; chk option&nbsp;&nbsp;&nbsp; Hide excluded in general tab</P></BODY></HTML> Thu, 05 May 2016 11:26:24 GMT https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081468#M919528 Chanty4u 2016-05-05T11:26:24Z Re: Limited records in List box https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081469#M919529 <HTML><HEAD></HEAD><BODY><P>‌Hi</P><P>YOu can limit the data in script</P><P></P><P>and also you can limit the values via put condition in expression tab of list box</P></BODY></HTML> Thu, 05 May 2016 11:26:25 GMT https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081469#M919529 2016-05-05T11:26:25Z Re: Limited records in List box https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081470#M919530 <HTML><HEAD></HEAD><BODY><P>How can we write condition in expression tab....</P></BODY></HTML> Thu, 05 May 2016 11:29:53 GMT https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081470#M919530 prma7799 2016-05-05T11:29:53Z Re: Limited records in List box https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081471#M919531 <HTML><HEAD></HEAD><BODY><P>You could use a listbox-expression like:</P><P></P><P>if(match(Country, 'A', 'B', ...), Country)</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 05 May 2016 11:32:32 GMT https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081471#M919531 marcus_sommer 2016-05-05T11:32:32Z Re: Limited records in List box https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081472#M919532 <HTML><HEAD></HEAD><BODY><P>It's better You create the field in script like below</P><P></P><P>LOAD ...</P><P><STRONG><EM>if(match(Country,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">'SRI LANKA',</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">'UNITED KINGDOM',</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">'IRELAND',</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">'TANZANIA',</SPAN></EM></STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;"><STRONG><EM>'INDIA') , Country) as CountryNew</EM></STRONG></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">...</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">FROM table</SPAN></P><P></P><P>Now you can use this Field in Listbox</P><P></P><P></P><P>Update :Corrected IF</P></BODY></HTML> Thu, 05 May 2016 11:37:42 GMT https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081472#M919532 Kushal_Chawda 2016-05-05T11:37:42Z Re: Limited records in List box https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081473#M919533 <HTML><HEAD></HEAD><BODY><P>The best thing is to filter out the needed countries in the script as a separate field. The other option is you can use below in the List box -expression:</P><P></P><P></P><P>=if( mixmatch([Country], 'SRI Lu ANKA','UNITED KINGDOM','IRELAND','TANZANIA','INDIA'), [Country])</P></BODY></HTML> Thu, 05 May 2016 11:38:24 GMT https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081473#M919533 trdandamudi 2016-05-05T11:38:24Z Re: Limited records in List box https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081474#M919534 <HTML><HEAD></HEAD><BODY><P>May be flag these in the script as 1 and then use the flag like this:</P><P></P><P><STRONG>If(Flag = 1, COUNTRY)</STRONG></P></BODY></HTML> Thu, 05 May 2016 11:43:51 GMT https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081474#M919534 sunny_talwar 2016-05-05T11:43:51Z Re: Limited records in List box https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081475#M919535 <HTML><HEAD></HEAD><BODY><P>HI</P><P>GO to list box properties</P><P>there select expression option under the field option in general tab</P><P>write logic a below</P><P>=if(match(country,</P><P><SPAN style="background-color: rgba(255, 255, 255, 0);">SRI LANKA</SPAN></P><P><SPAN style="background-color: rgba(255, 255, 255, 0);">UNITED KINGDOM</SPAN></P><P><SPAN style="background-color: rgba(255, 255, 255, 0);">IRELAND</SPAN></P><P><SPAN style="background-color: rgba(255, 255, 255, 0);">TANZANIA</SPAN></P><P><SPAN style="background-color: rgba(255, 255, 255, 0);">INDIA</SPAN></P><P>)</P><P></P><P></P><P>PLz put country names in quots</P></BODY></HTML> Thu, 05 May 2016 11:48:57 GMT https://community.qlik.com/t5/QlikView/Limited-records-in-List-box/m-p/1081475#M919535 2016-05-05T11:48:57Z