Multiple if expression doesn't work

[lmb93]

Hi everyone,

I'm trying to execute this expression which want to moltiply the value for a percentage which come as an everage of different values. if this is between 0.84 and 0.94 moltiply for 0.06,.. etc etc

qlik sense answer me that a ")" is expected.

How can I solve it? thanks in advantage

=((Sum([2019 YTD oe])/Sum([TARGET QTY oe]))+ if((Avg([Average of Correct Answer %]))='','',
if({Avg([Average of Correct Answer %])>=0.94},0.1,
IF({Avg([Average of Correct Answer %])>0.84},0.06,
IF((Avg([Average of Correct Answer %]))>0.8,0.03,
IF((Avg([Average of Correct Answer %]))>0.07,'',
IF((Avg([Average of Correct Answer %]))>0.64,-0.03,
IF((Avg([Average of Correct Answer %]))>0.59,-0.06,-0.1)
)
)
)
)
)
))

[Arthur_Fong · Accepted solution]

Try this:

=((Sum([2019 YTD oe])/Sum([TARGET QTY oe]))+
if(isnull(Avg([Average of Correct Answer %])),0,
if(Avg([Average of Correct Answer %])>=0.94,0.1,
IF(Avg([Average of Correct Answer %])>0.84,0.06,
IF(Avg([Average of Correct Answer %])>0.8,0.03,
IF(Avg([Average of Correct Answer %])>0.07,0,
IF(Avg([Average of Correct Answer %])>0.64,-0.03,
IF(Avg([Average of Correct Answer %])>0.59,-0.06,-0.1)
)
)
)
)
)
)
)

[Lisa_P]

Not sure about all your logic, try this:

=Sum([2019 YTD oe])/Sum([TARGET QTY oe])+
if(Avg([Average of Correct Answer %])='','',
if(Avg([Average of Correct Answer %])>= 0.94,0.1,
IF(Avg([Average of Correct Answer %]) >0.84,0.06,
IF(Avg([Average of Correct Answer %])> 0.8,0.03,
IF(Avg([Average of Correct Answer %]) > 0.7,'',
IF(Avg([Average of Correct Answer %])> 0.64,-0.03,
IF(Avg([Average of Correct Answer %])>0.59,-0.06,-0.1 )))))))

[lmb93]

Thank you very much. it works!

thank also to lisa 🙂