topic Re: Search String Select in Field with multiple limitations in QlikView https://community.qlik.com/t5/QlikView/Search-String-Select-in-Field-with-multiple-limitations/m-p/134923#M20206 <HTML><HEAD></HEAD><BODY><P>Thank you Stefan!</P><P></P><P>You have been most helpful, I did not really know how this should be defined and this solution worked perfectly.</P></BODY></HTML> Tue, 18 Sep 2018 06:30:50 GMT nikula22 2018-09-18T06:30:50Z Search String Select in Field with multiple limitations https://community.qlik.com/t5/QlikView/Search-String-Select-in-Field-with-multiple-limitations/m-p/134921#M20204 <HTML><HEAD></HEAD><BODY><P>Hello all!</P><P></P><P>After searching through this community and google I am unable to solve my problem.</P><P>I would like to be able to select certain weeks depending on the current week.</P><P>At the moment my Search String command is the following: </P><P>='&gt;=' &amp; (Week(today(2))-12), which returns all above the week 26 at the moment.</P><P></P><P>But what I would actually want to achieve is at current week (38) to select only weeks 26 to 37.</P><P>So '&gt;='&nbsp; &amp; (Week(today(2))-12) and '&lt;' &amp; Week(today(2)).</P><P></P><P>Unfortunately, this seems impossible at least with the current approach, any tips on this?</P></BODY></HTML> Mon, 17 Sep 2018 20:36:08 GMT https://community.qlik.com/t5/QlikView/Search-String-Select-in-Field-with-multiple-limitations/m-p/134921#M20204 nikula22 2018-09-17T20:36:08Z Re: Search String Select in Field with multiple limitations https://community.qlik.com/t5/QlikView/Search-String-Select-in-Field-with-multiple-limitations/m-p/134922#M20205 <HTML><HEAD></HEAD><BODY><P>How does your search string really looks like? I guess it should look like</P><P></P><P>=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> '&gt;='&nbsp; &amp; (Week(today(2))-12) &amp; '&lt;' &amp; Week(today(2))</SPAN></P></BODY></HTML> Mon, 17 Sep 2018 21:14:54 GMT https://community.qlik.com/t5/QlikView/Search-String-Select-in-Field-with-multiple-limitations/m-p/134922#M20205 swuehl 2018-09-17T21:14:54Z Re: Search String Select in Field with multiple limitations https://community.qlik.com/t5/QlikView/Search-String-Select-in-Field-with-multiple-limitations/m-p/134923#M20206 <HTML><HEAD></HEAD><BODY><P>Thank you Stefan!</P><P></P><P>You have been most helpful, I did not really know how this should be defined and this solution worked perfectly.</P></BODY></HTML> Tue, 18 Sep 2018 06:30:50 GMT https://community.qlik.com/t5/QlikView/Search-String-Select-in-Field-with-multiple-limitations/m-p/134923#M20206 nikula22 2018-09-18T06:30:50Z