topic Re: Help with If statement in QlikView

Help with If statement

hopkinsc — Fri, 10 Jul 2015 16:17:17 GMT

Hi all, i can't think properly today!

i am trying to create a new field in the script with the following conditions.

I have 6 fields (3 new and 3 old as below)

BusinessUnit

BusinessUnit_OLD

Department

Department_OLD

Division

Division_OLD

I want to create a flag field 'RoleChange_Flag' if the above do not match each other , i.e. if BusinessUnit <> BusinessUnit_OLD then 1 as RoleChange_Flag.

but i want RoleChange_Flag to be populated if either of them are different, so something like..

if(BusinessUnit<>BusinessUnit_OLD,1 or if(Department<>Department_OLD,1 or if(Division<>Division_OLD,1))) as RoleChange_Flag

I can't seem to get the syntax right.

any help would be appreciated

Re: Help with If statement

m_woolf — Fri, 10 Jul 2015 16:25:14 GMT

if(BusinessUnit<>BusinessUnit_OLD or Department<>Department_OLD or Division<>Division_OLD,1) as RoleChange_Flag

Re: Help with If statement

MK_QSL — Fri, 10 Jul 2015 16:26:56 GMT

If(BusinessUnit <> BusinessUnit_OLD or Department <> Department_OLD or Division <> Division_OLD,1) as RoleChange_Flag

Re: Help with If statement

hopkinsc — Fri, 10 Jul 2015 16:30:34 GMT

ahh, i was certain i needed to use multiple if statements!

Thankyou!