topic Re: help with if condition in QlikView

help with if condition

surajap123 — Wed, 14 May 2014 10:03:47 GMT

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!!

Wed, 14 May 2014 10:06:57 GMT

so you have to write,

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

hope this helps

regards,

jagan — Wed, 14 May 2014 10:15:42 GMT

Hi,

Try this in script

LOAD

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

FROM DataSource;

Regards,

Jagan.

nizamsha — Wed, 14 May 2014 10:20:18 GMT

Load *

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

from ur table;

surajap123 — Wed, 14 May 2014 10:25:02 GMT

Thanks everyone for your time..