Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

If statement in script - Error in expression: ')' expected

Hi folks,

while using following if statement in the load script I get the error: "Error in expression: ')' expected"

if(delta <= -3, 'Early > -3',

  if(delta <= 1, 'Early/+1',

  if(delta >= 1, 'late',

  if(delta >= -3 AND <= 1, 'On Time', 'n/a')))) as Delta_Classification,

Surfing different discussions they give the advice to use IF...THEN...END IF.

Nevertheless there wasn`t an example for multiple conditions like I have to use.

Can somebody help me?

Many thanks!

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

the error is:

if(delta >= -3 AND delta <= 1, .... just add delta <=1

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

the error is:

if(delta >= -3 AND delta <= 1, .... just add delta <=1

Not applicable
Author

Many thanks! Sometimes it is so easy...

Not applicable
Author

Hi Dave,

if(delta <= -3, 'Early > -3',

  if(delta <= 1, 'Early/+1',

  if(delta >= 1, 'late',

  if(delta >= -3 AND delta <= 1, 'On Time', 'n/a')))) as Delta_Classification,