Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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,