topic Re: match with * ?? in QlikView

match with * ??

Fri, 17 Oct 2014 13:31:09 GMT

Hi everybody i have a little question about match function and the * ( for example in SQL it may be something like this WHERE NAME = GO* and it selects all names that start with GO

is it possible this with the match function in QV? for example

WHERE MATCH(NAME, ´AL*´, ´PO'; )

etc...

Thank you all!

Re: match with * ??

Gysbert_Wassenaar — Fri, 17 Oct 2014 13:31:54 GMT

In Qlikview you can use the wildmatch function for wildcard matching.

Re: match with * ??

Fri, 17 Oct 2014 13:33:31 GMT

Thank you, then i have to do the same thing that i did with match but with WILDMATCH?

Re: match with * ??

Gysbert_Wassenaar — Fri, 17 Oct 2014 13:36:25 GMT

Yes, that's right.

Re: match with * ??

Fri, 17 Oct 2014 13:39:17 GMT

Thank you.

I´ll put a simple example , maybe this would help somebody.

FROM

xxxx.qvd

Where WildMatch(account, '2103*', '2108*', '2104*', '21021*', '21004*');