Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to cap a number

I am measuring the forecast accuracy.

Forecast=5

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!

1 Solution

Accepted Solutions

Re: How to cap a number

rangemin(1,1-fabs(actual-forecast)/actual)


talk is cheap, supply exceeds demand
2 Replies

Re: How to cap a number

rangemin(1,1-fabs(actual-forecast)/actual)


talk is cheap, supply exceeds demand
Not applicable

Re: How to cap a number


It works! Thank you a lot!

Community Browser