Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
jonesbrown
Contributor

Difference between match and mixmatch function where we use give me an example

Hi All

I am new to Qlikview

Difference between match and mixmatch function where we use give me an example 

plz help.

2 Replies
prma7799
Honored Contributor III

Re: Difference between match and mixmatch function where we use give me an example

match( str, expr1 [ , expr2,...exprN ] )

The match function performs a case sensitive comparison.

Example:

match( M, 'Jan','Feb','Mar')

returns 2 if M = Feb

returns 0 if M = Apr or jan

 

mixmatch( str, expr1 [ , expr2,...exprN ] )

 

The mixmatch function performs a case insensitive comparison.

Example:

mixmatch( M, 'Jan','Feb','Mar')

returns 1 if M = jan

 

wildmatch( str, expr1 [ , expr2,...exprN ] )

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

 

 

prma7799
Honored Contributor III

Re: Difference between match and mixmatch function where we use give me an example