topic Re: How to get Numbers from my list box in QlikView https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896421#M997379 <HTML><HEAD></HEAD><BODY><P>Hi SaiRamdc</P><P>Thanks to your reply</P><P></P><P>I want filter the data from "June 2003" to "may 2004" with "WHERE" condition in script level</P></BODY></HTML> Tue, 30 Jun 2015 06:26:30 GMT madhubabum 2015-06-30T06:26:30Z How to get Numbers from my list box https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896413#M997371 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>I have the following list box.....</P><P>DepartmentId:</P><P>ab_100</P><P>bc_200</P><P>st_300</P><P>100</P><P>200</P><P>300<BR />400</P><P></P><P>Sol: I want only 100,200,300,400....</P><P>How can we achieve this.</P></BODY></HTML> Thu, 25 Jun 2015 05:49:51 GMT https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896413#M997371 madhubabum 2015-06-25T05:49:51Z Re: How to get Numbers from my list box https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896414#M997372 <HTML><HEAD></HEAD><BODY><P>Use this expression in your list box:</P><P></P><P>=Aggr(If(IsNum(DepartmentId), <SPAN style="font-size: 13.3333330154419px;">DepartmentId), <SPAN style="font-size: 13.3333330154419px;">DepartmentId)</SPAN></SPAN></P></BODY></HTML> Thu, 25 Jun 2015 05:52:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896414#M997372 jonathandienst 2015-06-25T05:52:04Z Re: How to get Numbers from my list box https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896415#M997373 <HTML><HEAD></HEAD><BODY><P>=if(IsNum(DepartmentId),DepartmentId)</P></BODY></HTML> Thu, 25 Jun 2015 05:57:19 GMT https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896415#M997373 2015-06-25T05:57:19Z Re: How to get Numbers from my list box https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896416#M997374 <HTML><HEAD></HEAD><BODY><P>Hi Thanks to reply</P><P></P><P>But with the help of Inner Join ......I want to make changes in DataModel</P></BODY></HTML> Thu, 25 Jun 2015 05:58:18 GMT https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896416#M997374 madhubabum 2015-06-25T05:58:18Z Re: How to get Numbers from my list box https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896417#M997375 <HTML><HEAD></HEAD><BODY><P>In list box properties, ---&gt; select Expression from field drop down ------&gt; edit --------&gt; use the below expression. and it should bring only the selected field values</P><P></P><P>=if(match(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DepartmentId</SPAN>,'100','200','300','400'), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DepartmentId)</SPAN></P></BODY></HTML> Thu, 25 Jun 2015 05:58:43 GMT https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896417#M997375 Anonymous 2015-06-25T05:58:43Z Re: How to get Numbers from my list box https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896418#M997376 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P>&nbsp;&nbsp;&nbsp;&nbsp; DepartmentId As AllDepartmentIds,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">If(IsNum(DepartmentId), </SPAN><SPAN style="font-size: 13.3333330154419px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">DepartmentId) As DepartmentId,</SPAN></P><P><SPAN style="font-size: 13.3333330154419px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; ...</SPAN></P></BODY></HTML> Thu, 25 Jun 2015 05:59:42 GMT https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896418#M997376 jonathandienst 2015-06-25T05:59:42Z Re: How to get Numbers from my list box https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896419#M997377 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this in your script. (if you have only one underscore in your data)</P><P></P><P>subfield(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DepartmentId,'_',2) as DepartmentId</SPAN></P></BODY></HTML> Thu, 25 Jun 2015 06:02:43 GMT https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896419#M997377 settu_periasamy 2015-06-25T06:02:43Z Re: How to get Numbers from my list box https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896420#M997378 <HTML><HEAD></HEAD><BODY><P>another solution could be:</P><P><BR />KeepChar(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DepartmentId, '0123456789')</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN>please elaborate on your requirements to be able to deliver correct answers.</P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Fri, 26 Jun 2015 18:56:35 GMT https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896420#M997378 MarcoWedel 2015-06-26T18:56:35Z Re: How to get Numbers from my list box https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896421#M997379 <HTML><HEAD></HEAD><BODY><P>Hi SaiRamdc</P><P>Thanks to your reply</P><P></P><P>I want filter the data from "June 2003" to "may 2004" with "WHERE" condition in script level</P></BODY></HTML> Tue, 30 Jun 2015 06:26:30 GMT https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896421#M997379 madhubabum 2015-06-30T06:26:30Z Re: How to get Numbers from my list box https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896422#M997380 <HTML><HEAD></HEAD><BODY><P>try like this:</P><P></P><P>Load * </P><P></P><P>from </P><P>table</P><P>where monthname(datecolumn)&gt;=monthname(makedate(2003,06) and <SPAN style="font-size: 13.3333330154419px;">monthname(datecolumn)&lt;=monthname(makedate(2004,05)</SPAN></P></BODY></HTML> Tue, 30 Jun 2015 06:36:06 GMT https://community.qlik.com/t5/QlikView/How-to-get-Numbers-from-my-list-box/m-p/896422#M997380 avinashelite 2015-06-30T06:36:06Z