Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

wildmatch() and wildmatch5()

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: wildmatch() and wildmatch5()

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

View solution in original post

4 Replies
Highlighted
Not applicable

Re: wildmatch() and wildmatch5()

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

View solution in original post

Highlighted
Not applicable

Re: wildmatch() and wildmatch5()

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

Highlighted
Not applicable

Re: wildmatch() and wildmatch5()

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

???

Highlighted
Not applicable

Re: wildmatch() and wildmatch5()

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