topic if statement in script more than 3 conditions !?!! in QlikView

if statement in script more than 3 conditions !?!!

Tue, 31 May 2011 10:21:16 GMT

Hi Guys Yesterday I was helped put an If statement in the script, if( [Was backvaluation required ?] ='Yes' and [Issue held with] = 'Cops Team','Yes','No') as [Corp Ops Backvaluation] It works a charm !!! But today I need to amend it a little, I need to add in another and where [Type of Event] is not "Margin Change" I have tried the following but getting an Error in expression: ')' expectedon load if( [Was backvaluation required ?] ='Yes' and [Issue held with] = 'Cops Team' and [Type of Event] not 'Margin Change' ,'Yes','No') Pleeeeaaasseee Help Thanks Anne

if statement in script more than 3 conditions !?!!

Tue, 31 May 2011 10:22:18 GMT

*** DONT KNOW WHAT HAPPENED FORMAT ABOVE ***

Hi Guys

Yesterday I was helped put an If statement in the script,

if( [Was backvaluation required ?] ='Yes' and [Issue held with] = 'Cops Team','Yes','No') as [Corp Ops Backvaluation]

It works a charm !!!

But today I need to amend it a little, I need to add in another and where [Type of Event] is not "Margin Change" I have tried the following but getting an Error in expression: ')' expectedon load

if( [Was backvaluation required ?] ='Yes' and [Issue held with] = 'Cops Team' and [Type of Event] not 'Margin Change' ,'Yes','No')

Pleeeeaaasseee Help

Thanks Anne

if statement in script more than 3 conditions !?!!

pat_agen — Tue, 31 May 2011 10:24:07 GMT

hi,

change

not 'Margin Change' "

<> 'Margin Change'

that should do the trick.

if statement in script more than 3 conditions !?!!

Tue, 31 May 2011 10:25:44 GMT

Thanks Pat , just realised that!

All working good now

Thanks