Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
What is the difference between Match and wildMatch function.
When you are use WildMatch function QV. Both are same functionality in 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.
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.
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.