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

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

jonesbrown — Sat, 16 Nov 2024 19:42:08 GMT

Hi All

I am new to Qlikview

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

plz help.

prma7799 — Mon, 11 Nov 2019 06:25:01 GMT

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 — Mon, 11 Nov 2019 06:25:26 GMT