topic Re: help with MATCH function in QlikView

help with MATCH function

hopkinsc — Wed, 11 Dec 2013 11:18:44 GMT

hi all,

I am having trouble with the MATCH function.

It needs 2 parameters to work but i want the 2nd parameter to be null.

how can i achieve this?

I am currently trying.

WHERE match(Scope,)

but its throwing up an error .

abeyphilip — Wed, 11 Dec 2013 11:21:59 GMT

Hi,

If your objective is to find nulls, then you can use - isnull(Scope).

Or else for blanks (single blank) - match(scope,' ')

Regards,

Abey

bbi_mba_76 — Wed, 11 Dec 2013 11:23:04 GMT

Hi,

I think you have to change the function: for null values you could use the isnull() function or len(Scope)<1

Anonymous — Wed, 11 Dec 2013 11:24:06 GMT

Actually what is your requirement.

Please explain in brief.

Regards

Nitin

MayilVahanan — Wed, 11 Dec 2013 12:01:17 GMT

Try like this

WHERE Len(Trim(Scope)) = 0;