Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

the error is:

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

3 Replies

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

the error is:

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

Not applicable

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

Many thanks! Sometimes it is so easy...

Not applicable

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

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,

Community Browser