topic load and IF Statement in QlikView

load and IF Statement

leocattqv — Tue, 20 Oct 2015 17:05:04 GMT

Hi there,

I am having some difficulty with the syntax of the if statement in my load. I am attempting to say

IF [Field] = Yes OR No, then True, False

the syntax I have is

if (([Field1])='Yes' or ([Field1])='No', 'Reviewed') as REVIEW

im sure this is a simple one but Im stuck, any suggestions?

swuehl — Tue, 20 Oct 2015 17:14:56 GMT

What is exactely your issue?

LOAD *,

if (([Field1])='Yes' or ([Field1])='No', 'Reviewed') as REVIEW

INLINE [

Field1

Yes

Maybe

];

seems to work for me.

leocattqv — Tue, 20 Oct 2015 20:44:41 GMT

Hi,

Qlik doesnt seem to like the comma between 'No', and 'Reviewed'

I get an error in the script

(([Field1])='Yes' or ([Field1])='No', 'Reviewed') as REVIEW,

swuehl — Tue, 20 Oct 2015 22:06:18 GMT

Please post your complete Load statement.

MarcoWedel — Tue, 20 Oct 2015 22:08:35 GMT

Hi,

If(Field1='Yes' or Field1='No', 'Reviewed') as REVIEW

If(Match(Field1,'Yes','No'), 'Reviewed') as REVIEW

should also work.

No reason for a comma causing an error.

Maybe it would help if you posted the error message and some sample data?

thanks

regards

Marco

raman_rastogi — Wed, 21 Oct 2015 04:29:38 GMT

try this

if(Field1='yes','true',if(Field1='no','false'))