topic Re: Search for string in listbox in QlikView https://community.qlik.com/t5/QlikView/Search-for-string-in-listbox/m-p/1350656#M515948 <HTML><HEAD></HEAD><BODY><P>Perfect, thanks!</P></BODY></HTML> Thu, 20 Apr 2017 16:50:58 GMT Anonymous 2017-04-20T16:50:58Z Search for string in listbox https://community.qlik.com/t5/QlikView/Search-for-string-in-listbox/m-p/1350653#M515945 <HTML><HEAD></HEAD><BODY><P>Hi guys, </P><P></P><P>I need to put an action in a button to filter a listbox with the string 'FCST'. This listbox contains values like <SPAN style="font-size: 13.3333px;">'FCST1', <SPAN style="font-size: 13.3333px;">'FCST2', <SPAN style="font-size: 13.3333px;">'FCST1'</SPAN>, 'BGT' etc.</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">The problem is, I need to get the maximum nr. after <SPAN style="font-size: 13.3333px;">'FCST', in that case <SPAN style="font-size: 13.3333px;">'FCST3'.</SPAN></SPAN></SPAN></P><P></P><P>Something like that: (but doesn't work..)</P><P>=If(Max(Right(WildMatch(Myfield,'FCST*'),1)),<SPAN style="font-size: 13.3333px;">Myfield</SPAN>)</P><P></P><P>Any thoughts?</P></BODY></HTML> Thu, 20 Apr 2017 13:03:11 GMT https://community.qlik.com/t5/QlikView/Search-for-string-in-listbox/m-p/1350653#M515945 Anonymous 2017-04-20T13:03:11Z Re: Search for string in listbox https://community.qlik.com/t5/QlikView/Search-for-string-in-listbox/m-p/1350654#M515946 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=MaxString({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Myfield</SPAN> = {'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">FCST*</SPAN>'}&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Myfield</SPAN>)</STRONG></P></BODY></HTML> Thu, 20 Apr 2017 15:46:32 GMT https://community.qlik.com/t5/QlikView/Search-for-string-in-listbox/m-p/1350654#M515946 sunny_talwar 2017-04-20T15:46:32Z Re: Search for string in listbox https://community.qlik.com/t5/QlikView/Search-for-string-in-listbox/m-p/1350655#M515947 <HTML><HEAD></HEAD><BODY><P>use select in field for myfield and then</P><P></P><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">=</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: blue;">MaxString</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">({&lt;</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">myfield</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;"> ={</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">"FCST*"</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">}&gt;}</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: maroon;">myfield</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Arial','sans-serif'; color: black;">) </SPAN></P></BODY></HTML> Thu, 20 Apr 2017 15:47:43 GMT https://community.qlik.com/t5/QlikView/Search-for-string-in-listbox/m-p/1350655#M515947 Anonymous 2017-04-20T15:47:43Z Re: Search for string in listbox https://community.qlik.com/t5/QlikView/Search-for-string-in-listbox/m-p/1350656#M515948 <HTML><HEAD></HEAD><BODY><P>Perfect, thanks!</P></BODY></HTML> Thu, 20 Apr 2017 16:50:58 GMT https://community.qlik.com/t5/QlikView/Search-for-string-in-listbox/m-p/1350656#M515948 Anonymous 2017-04-20T16:50:58Z