Discussion Board for collaboration related to Creating Analytics for QlikView.
I am measuring the forecast accuracy.
Actual = 1
Forecast Accuracy = 1-abs(actual-forecast)/actual = 1- 400%= -300% But I need it to be 0%
I'd like to either cap 400% to be 100% or -300% to 0%. Is there a cap function in Qlikview? Thanks!
Go to Solution.
It works! Thank you a lot!