Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Difference between Match and wildMatch function on QV.

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'
Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Difference between Match and wildMatch function on QV.

Hi

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.

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Difference between Match and wildMatch function on QV.

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Difference between Match and wildMatch function on QV.

Hi

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.