Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community,
I am developing a Qlik Sense App and struggle with the following KPI formula:
=IF(-(SUM(Target_rev * year_flag)-SUM(Erloese_Netto*year_flag))/Sum(Target_rev) = 0, '' , -(SUM(Target_rev * year_flag)-SUM(Erloese_Netto*year_flag))/Sum(Target_rev) )
The error message is:
Garbage after expression '=IF(-(SUM(Target_rev * year_flag)-SUM(Erloese_Netto*year_flag))/Sum(Target_rev) = 0, '' , -(SUM(Target_rev * year_flag)-SUM(Erloese_Netto*year_flag))/Sum(Target_rev) )'
Can you help me finding the error?
Thanks a lot.
Gregor
Thank you sir!!