topic Re: How to simplify my expression on search string ? in QlikView https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427592#M159344 <HTML><HEAD></HEAD><BODY><P>Valueloop and valuelist functions are used for calculated dimensions.</P><P></P><P>they cant be used as search string</P></BODY></HTML> Mon, 06 May 2013 06:53:20 GMT sushil353 2013-05-06T06:53:20Z How to simplify my expression on search string ? https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427588#M159340 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>Now i use a button for filter Current Asset </P><P></P><P></P><P>On the action, i choose = select in field&nbsp; :- field name i enter "Reporting Code"</P><P></P><P></P><P>On the search string i enter :-</P><P></P><P></P><P>(50010|50011|50016|50020|50021|50022|50012|50024|50028|50014|50029|50013|50025|50026|50030|50035|50040|50051|50043|50050|50092|50053|50055|50056|50057|50058|50059|50060|50065|50083|50075|50085|50090)</P><P></P><P></P><P>My question is it there any short cut where i can write &gt;=50010 &lt;= 50090 ? ( Since the number is running from 50010 till 50090. )</P><P></P><P></P><P>Paul</P></BODY></HTML> Mon, 06 May 2013 06:07:32 GMT https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427588#M159340 paulyeo11 2013-05-06T06:07:32Z Re: How to simplify my expression on search string ? https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427589#M159341 <HTML><HEAD></HEAD><BODY><P>try this</P><P></P><P>ValueLoop(50010,50090,1)</P></BODY></HTML> Mon, 06 May 2013 06:17:04 GMT https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427589#M159341 2013-05-06T06:17:04Z Re: How to simplify my expression on search string ? https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427590#M159342 <HTML><HEAD></HEAD><BODY><P>Hi Sir</P><P></P><P>I try but it still not working. See the enclosed file.</P></BODY></HTML> Mon, 06 May 2013 06:43:23 GMT https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427590#M159342 paulyeo11 2013-05-06T06:43:23Z Re: How to simplify my expression on search string ? https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427591#M159343 <HTML><HEAD></HEAD><BODY><P>try with equal sign</P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">=' &gt;=50010 &amp; &lt;= 50090'</SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">but i works for me</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">click on button after doing it<BR /></SPAN></P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">see the attached file<BR /></SPAN></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;"><BR /></SPAN></P></BODY></HTML> Mon, 06 May 2013 06:53:02 GMT https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427591#M159343 er_mohit 2013-05-06T06:53:02Z Re: How to simplify my expression on search string ? https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427592#M159344 <HTML><HEAD></HEAD><BODY><P>Valueloop and valuelist functions are used for calculated dimensions.</P><P></P><P>they cant be used as search string</P></BODY></HTML> Mon, 06 May 2013 06:53:20 GMT https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427592#M159344 sushil353 2013-05-06T06:53:20Z Re: How to simplify my expression on search string ? https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427593#M159345 <HTML><HEAD></HEAD><BODY><P>I try your advise , same it does not work.</P></BODY></HTML> Mon, 06 May 2013 06:56:34 GMT https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427593#M159345 paulyeo11 2013-05-06T06:56:34Z Re: How to simplify my expression on search string ? https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427594#M159346 <HTML><HEAD></HEAD><BODY><P>Hi Paul,</P><P></P><P>This one seem to work </P><P>='&gt;=' &amp; 50001 &amp; '&lt;=' &amp; 50090</P><P></P><P>Regards,</P><P>Sokkorn</P></BODY></HTML> Mon, 06 May 2013 07:08:41 GMT https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427594#M159346 Sokkorn 2013-05-06T07:08:41Z Re: How to simplify my expression on search string ? https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427595#M159347 <HTML><HEAD></HEAD><BODY><P>wonderful , it work now. many thank.</P></BODY></HTML> Mon, 06 May 2013 07:10:15 GMT https://community.qlik.com/t5/QlikView/How-to-simplify-my-expression-on-search-string/m-p/427595#M159347 paulyeo11 2013-05-06T07:10:15Z