help with if condition

[surajap123]

Hi All,

I want to write a if condition in qlikview script as per the below requirement.

-when field1= 10 and field2<>10, then field3 should be 0, otherwise keep the value of field3 coming from source.

For more information, all the 3 fields are present in the same table.

please help!!

[#2 · Accepted solution]

so you have to write,

if(fiels1=10 and field2<>10,0,field3) as field3

hope this helps

regards,

MT

[jagan]

Hi,

Try this in script

LOAD

*,

If(field1= 10 AND field2<>10, 0, field3) AS field3

FROM DataSource;

Regards,

Jagan.

[nizamsha]

Load *

if(Field1=0 and field2 <>0,0,field3) as Field3

from ur table;

[surajap123]

Thanks everyone for your time..