# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for
Did you mean:  Contributor II

## Multiple if expression doesn't work

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 %]))='','',
)
)
)
)
)
))

1 Solution

Accepted Solutions  Partner - Specialist III

Try this:

=((Sum([2019 YTD oe])/Sum([TARGET QTY oe]))+
)
)
)
)
)
)
)

3 Replies  Partner - Specialist III

Try this:

=((Sum([2019 YTD oe])/Sum([TARGET QTY oe]))+
)
)
)
)
)
)
)  Employee

=Sum([2019 YTD oe])/Sum([TARGET QTY oe])+
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 )))))))  Contributor II
Author

Thank you very much. it works!

thank also to lisa 🙂 Tags
Community Browser