topic Re: wildmatch() and wildmatch5() in QlikView

wildmatch() and wildmatch5()

Sun, 10 Nov 2013 16:12:40 GMT

What is the difference between WildMatch() and WildMatch5() functions?

Sun, 10 Nov 2013 17:07:02 GMT

hi,

Wildmatch() is a QlikView Function and wildmatch5() is not anymore.

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters (

* and ?) in the comparison strings.

Example:

wildmatch( M, 'ja*','fe?','mar')

returns 1 if M = January

returns 2 if M = fex

Wildmatch5(s,expr1 [,expr2,...exprN])

Works as the above wildmatch function, but is used only for compatibility

reasons with QlikView version 5.

Regards,

Gerrit

Sun, 10 Nov 2013 17:19:02 GMT

Thanks. I had seen that quesion here: http://qlikshare.com/qotd, and wondered whether it meant anything.

Thu, 22 May 2014 23:20:45 GMT

Chris, If I have a table like this:

Column A

TEST

test

TeSt

and in the load i do:

Load

wildmatch (Column A) it will all group as:

Column A

test

???

Tue, 25 Nov 2014 08:09:10 GMT

Hi,

Have you got any answer on your question asked in qlikview.

I also have the same kind of requirement.

If you got anything do share..

Thks

Poshkant