Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
the error is:
if(delta >= -3 AND delta <= 1, .... just add delta <=1
Many thanks! Sometimes it is so easy...
if(delta >= -3 AND delta <= 1, 'On Time', 'n/a')))) as Delta_Classification,