topic Difference between Match and wildMatch function on QV. in QlikView

Difference between Match and wildMatch function on QV.

Fri, 20 Dec 2013 17:03:48 GMT

Hi All,

What is the difference between Match and wildMatch function.

When you are use WildMatch function QV. Both are same functionality in QV?

when you use Match() in a where clause, you will have a condition that is very similar to the SQL “IN” operator. Further, with the WildMatch() function you can use wildcards, just like in the SQL “LIKE” operator:

Load … Where Match(Char, 'A','B') or WildMatch(Name,'*son')

SQL SELECT … WHERE Char IN ('A','B') OR Name LIKE '%son'

Re: Difference between Match and wildMatch function on QV.

Gysbert_Wassenaar — Fri, 20 Dec 2013 17:06:05 GMT

I suggest you install Qlikview and then open Qlikview and press F1 to open the help file. Then read both help file entries for Match and Wildmatch. The information is there in the help file. Really it is. Honestly. I'm not kidding.

Re: Difference between Match and wildMatch function on QV.

Fri, 20 Dec 2013 18:55:43 GMT

Match() is used for a case sensitive comparison. It matches the exact searchstring you pass in the function.

for Example: Match(Name,'Raja') , returns true if a person's name is exactly Raja (R caps).

WildMatch is used for a match where a string can be part of the search string.

For example :Match(Name,'Raja') will return true if a person's name is Raja, Maharaja, Rajan, or Rajat or some other string containing Raja in it.

MixMatch is same as Match but it is case insensitive.