topic how to use fuzzy text filter in table expression in QlikView https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332167#M493341 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> wildmatch() function should help you.</P></BODY></HTML> Thu, 31 May 2012 20:27:39 GMT 2012-05-31T20:27:39Z how to use fuzzy text filter in table expression https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332166#M493340 <HTML><HEAD></HEAD><BODY><P>a variable can have the following values: RAP A, RAP B, RAP C, ABC, CDE</P><P></P><P>In an expression I want only the values starting with RAP in my selection. How to do so without the need to type in all values?</P><P></P><P>=SUM({$&lt;variable = {'RAP...??}&gt;}Sales)</P><P></P><P></P><P><SPAN style="font-family: 'Arial','sans-serif'; color: #7030a0; font-size: 10pt;"><SPAN style="color: #7030a0;" title="mailto:Marieke.kranenburg@jeugdzorgnederland.nl"> </SPAN></SPAN></P></BODY></HTML> Thu, 31 May 2012 19:58:06 GMT https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332166#M493340 2012-05-31T19:58:06Z how to use fuzzy text filter in table expression https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332167#M493341 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> wildmatch() function should help you.</P></BODY></HTML> Thu, 31 May 2012 20:27:39 GMT https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332167#M493341 2012-05-31T20:27:39Z Re: how to use fuzzy text filter in table expression https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332168#M493342 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'courier new', courier;">=SUM({$&lt;variable = {"RAP*"}&gt;}Sales)</SPAN></P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://robwunderlich.com">http://robwunderlich.com</A></P></BODY></HTML> Thu, 31 May 2012 20:33:50 GMT https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332168#M493342 rwunderlich 2012-05-31T20:33:50Z Re: how to use fuzzy text filter in table expression https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332169#M493343 <HTML><HEAD></HEAD><BODY><P>Thanks Rob, that worked.</P><P></P><P>Nicole</P><P></P><P>Van: Rob Wunderlich <A href="mailto:qliktech@sgaur.hosted.jivesoftware.com"></A></P><P>Verzonden: donderdag 31 mei 2012 22:34</P><P>Aan: Nicole Kooij-Lemmen</P><P>Onderwerp: <A href="Development (QlikView Desktop)"></A> - Re: how to use fuzzy text filter in table expression</P><P></P><P>QlikCommunity&lt;http://community.qlik.com/index.jspa&gt;</P><P></P><P>Re: how to use fuzzy text filter in table expression</P><P>created by Rob Wunderlich&lt;http://community.qlik.com/people/robwunderlich&gt; in Development (QlikView Desktop) - View the full discussion&lt;http://community.qlik.com/message/224580#224580</P></BODY></HTML> Tue, 05 Jun 2012 12:17:42 GMT https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332169#M493343 2012-06-05T12:17:42Z Re: how to use fuzzy text filter in table expression https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332170#M493344 <HTML><HEAD></HEAD><BODY><P>Nicole,</P><P></P><P>Please mark the answer as correct to close the thread. </P><P></P><P>Thanks,</P><P>Rob</P></BODY></HTML> Tue, 05 Jun 2012 16:34:04 GMT https://community.qlik.com/t5/QlikView/how-to-use-fuzzy-text-filter-in-table-expression/m-p/332170#M493344 rwunderlich 2012-06-05T16:34:04Z