Discussion board where members can get started with QlikView.
what is the diff btn wildmatch and wildmatch5?
Did you check this?
wildmatch() and wildmatch5()
wildmatch( s, expr1 [ , expr2, ...exprN ] )
Compares the string s to a list of strings or string expressions. The
result of the comparison is an integer indicating which of the comparison
strings/expressions that matched. If no match is found, 0 is
returned. The wildmatch function performs a case insensitive comparison.
The wildcard characters * and ? are allowed in the comparison
wildmatch( M , 'ja*' , 'fe?' , 'mar' )
where M is 'January' returns 1
where M is 'fex' returns 2
Works as the above wildmatch function, but is used only for compatibility
reasons with QlikView version 5