Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

how to use fuzzy text filter in table expression

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)

1 Solution

Accepted Solutions

Re: how to use fuzzy text filter in table expression

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

-Rob

http://robwunderlich.com

4 Replies
Not applicable

how to use fuzzy text filter in table expression

Hi,

wildmatch() function should help you.

Re: how to use fuzzy text filter in table expression

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

-Rob

http://robwunderlich.com

Not applicable

Re: how to use fuzzy text filter in table expression

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

Re: how to use fuzzy text filter in table expression

Nicole,

Please mark the answer as correct to close the thread.

Thanks,

Rob

Community Browser