Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

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

1 Solution

Accepted Solutions
pat_agen
Valued Contributor

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

hi,

change

     not 'Margin Change' "

to

     <> 'Margin Change' 

that should do the trick.

3 Replies
Not applicable

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

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

pat_agen
Valued Contributor

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

hi,

change

     not 'Margin Change' "

to

     <> 'Margin Change' 

that should do the trick.

Not applicable

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

Thanks Pat , just realised that!

All working good now

Thanks

Community Browser