topic Re: IF Match in QlikView

IF Match

Fri, 04 Apr 2014 13:00:16 GMT

Hello ,

Can you please point me to the right direction?

I am trying to run below script;

LOAD CATALOG,

IF (match(KITCHEN,BEDROOM, KITCHEN1, KITCHEN2, BEDROOM1));

SQL SELECT *

FROM database.dbo."database_name"

WHERE STATUS<>'XX'

;

not working, the error message is;

Error in expression:

If takes 2-3 parameters

What I am doing wrong?

Thank you in advance, all little helps 🙂

tresB — Fri, 04 Apr 2014 13:04:41 GMT

The wrong expression part is:

IF (match(KITCHEN,BEDROOM, KITCHEN1, KITCHEN2, BEDROOM1));

If( <cond>, Then do this) // you are missing this part

Not only that, probably your Match() is not right.

sivarajs — Fri, 04 Apr 2014 14:41:40 GMT

you should give field name in match condition

match(fieldname,'string1','string2'...)

You are missing action part in If condition as tresesco mentioned

Fri, 04 Apr 2014 14:55:31 GMT

We could help you better if you can post what you're trying to achieve.

Fri, 04 Apr 2014 15:50:22 GMT

All sorted out now. Thanks for all the help, much appreciated. Elizabeth