If Statement within a Calculated Field

[MikeJones]

Hi, I wish to create a new filed using the Calculated Field for the following in Qlik Sense.  The table I am using has JobStatus, the column MikeStatus is my desired result.  I have been successful when using an If statement for only one  condition e.g. if(JobStatus='Completed','Completed','XXX'), however when I try to introduce more than one condition I get missing parenthesis.

JobStatus	Mike Status
Completed	Completed
Full Abort	Full Abort
Engine Abort	Completed
Completed	Completed
Gin Abort	Completed
Engine Abort	Completed
Full Abort	Full Abort
Completed	Completed
Completed	Completed

[Mark_Little]

Hi @MikeJones 

Can you share your full if statement and there error you are seeing?

What you shared is valid, but i assuming the 'XXX' isn't your else argument.

[vinieme12]

Can you post the actual script you used?

[MikeJones]

Hi, the script I have tried is if(JobStatus='Completed', or JobStatus='Engine Abort','Completed',JobStatus)

[vinieme12 · Accepted solution]

You have an extra comma here after 'completed'

if(JobStatus='Completed' or JobStatus='Engine Abort','Completed',JobStatus)