Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
a variable can have the following values: RAP A, RAP B, RAP C, ABC, CDE
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?
=SUM({$<variable = {'RAP...??}>}Sales)
Hi,
wildmatch() function should help you.
Thanks Rob, that worked.
Nicole
Verzonden: donderdag 31 mei 2012 22:34
Aan: Nicole Kooij-Lemmen
Onderwerp: - Re: how to use fuzzy text filter in table expression
QlikCommunity<http://community.qlik.com/index.jspa>
Re: how to use fuzzy text filter in table expression
created by Rob Wunderlich<http://community.qlik.com/people/robwunderlich> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/224580#224580
Nicole,
Please mark the answer as correct to close the thread.
Thanks,
Rob