case to if

[#1]

Hi all,

I'm trying to replicate the below statement in qlikview load script.

CASE WHEN (`Field1`-`Field2`) = 0 AND `Field3` = 0 THEN 'No' ELSE 'Yes' END

Thanks

[vishsaggi · Accepted solution]

May be this?

IF(Field1-Field2 = 0 AND Field3 = 0, 'No', 'Yes') AS YourNewFieldName

[ahaahaaha]

Hi,

May be (for script code)

IF Field1-Field2 = 0 And Field3 = 0

'No'

ELSE

'Yes'

END IF

[zhuravlevleonid]

Didnt you forget to add word "SQL" before Select?

[#5]

Thank you Vishwarath

[Sergey_Shuklin]

Hello, Naveen!

It's the same is (if you want it within script):

IF(Field1-Field2=0 AND Field3=0,'No','Yes') as FLG