how to use fuzzy text filter in table expression

[#1]

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)

[#2]

Hi,

wildmatch() function should help you.

[rwunderlich · Accepted solution]

=SUM({$<variable = {"RAP*"}>}Sales)

-Rob

http://robwunderlich.com

[#4]

Thanks Rob, that worked.

Nicole

Van: Rob Wunderlich

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

[rwunderlich]

Nicole,

Please mark the answer as correct to close the thread.

Thanks,

Rob