Difference between Match and wildMatch function on QV.
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'
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.