topic Re: wildmatch()? in QlikView

wildmatch()?

Mon, 24 Nov 2014 13:26:04 GMT

What it the result of below statement?

wildmatch(Country,'IN*') >0

Re: wildmatch()?

maleksafa — Mon, 24 Nov 2014 13:27:50 GMT

wildmatch(Country,'IN*') will return 1 if the Country starts with 'IN', this might be a condition to show or hide a value based on the country name again if it starts with IN

Re: wildmatch()?

anbu1984 — Mon, 24 Nov 2014 13:36:26 GMT

wildmatch(Country,'IN*') >0 -- Similar to Country LIke 'IN%' in Sql

Re: wildmatch()?

datanibbler — Mon, 24 Nov 2014 13:42:23 GMT

Simple: WildMatch() allows for Wildcards

- * for any number of digits

- ? for exactly one digit

Re: wildmatch()?

Mon, 24 Nov 2014 14:49:01 GMT

That thing i know but why we use >0 here plz tell me

Re: wildmatch()?

rubenmarin — Mon, 24 Nov 2014 15:00:22 GMT

Hi rakesh, match and wildmatch returns an integer telling the first expression to search that was found, and 0 (zero) in case none was found.

=WildMatch('ABCD', 'AB*', '*CD') --> Returns 1 (the 1st "search expression" was found)

=WildMatch('ABCD', '*AB', '*CD') --> Returns 2 (the 2nd "search expression" was found)

So asking for >0 is telling that one of the search strings was found.

Re: Re: wildmatch()?

MarcoWedel — Mon, 24 Nov 2014 16:32:43 GMT

Hi,

in case you are using this expression as a condition like

If(wildmatch(Country,'IN*') >0, returnvalue1, returnvalue2)

then you can skip the >0 part:

If(wildmatch(Country,'IN*'), returnvalue1, returnvalue2)

will work the same way, because this comparison also returns a non-zero value (true = -1) in case country matches 'IN*'.

hope this helps

regards

Marco