Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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'
1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

2 Replies
Gysbert_Wassenaar

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
Author

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.