topic NOT match function. in QlikView

NOT match function.

Mon, 23 Apr 2012 16:25:06 GMT

Hi community, Is there anyway to make a not match function. I know that there is a match function. I am wondering if there is a complement to it or how one would go about doing it with an if statement?

NOT match function.

d_pranskus — Mon, 23 Apr 2012 16:38:59 GMT

What are you want to achieve?

This is MATCH function. It will return 0 if it doesn't find str in expr..exprN.

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

Hope it helps

Cheers

Darius

NOT match function.

Mon, 23 Apr 2012 16:46:42 GMT

I want it to return 0 if there is a match.

NOT match function.

d_pranskus — Mon, 23 Apr 2012 17:38:17 GMT

The shortest way I came up with is to use following expression

1-SIGN(MATCH(str, expr1 [ , expr2,...exprN ]))

Cheers

Darius

NOT match function.

CELAMBARASAN — Mon, 23 Apr 2012 18:05:31 GMT

Hi,

You can get it as many ways

simply Not Match() gives you 0 if there is a match otherwise -1.

1+(Match()>0) gives you 0 if there is a match otherwise -1.

1-Sign(Match()) gives you 0 if there is a match otherwise -1.

Celambarasan