topic How to cap a number in QlikView https://community.qlik.com/t5/QlikView/How-to-cap-a-number/m-p/488223#M480765 <HTML><HEAD></HEAD><BODY><P>I am measuring the forecast accuracy.</P><P>Forecast=5</P><P>Actual = 1</P><P>Forecast Accuracy = 1-abs(actual-forecast)/actual = 1- 400%= -300% But I need it to be 0%</P><P></P><P>I'd like to either cap 400% to be 100% or -300% to 0%. Is there a cap function in Qlikview? Thanks!</P></BODY></HTML> Wed, 06 Nov 2013 17:19:45 GMT 2013-11-06T17:19:45Z How to cap a number https://community.qlik.com/t5/QlikView/How-to-cap-a-number/m-p/488223#M480765 <HTML><HEAD></HEAD><BODY><P>I am measuring the forecast accuracy.</P><P>Forecast=5</P><P>Actual = 1</P><P>Forecast Accuracy = 1-abs(actual-forecast)/actual = 1- 400%= -300% But I need it to be 0%</P><P></P><P>I'd like to either cap 400% to be 100% or -300% to 0%. Is there a cap function in Qlikview? Thanks!</P></BODY></HTML> Wed, 06 Nov 2013 17:19:45 GMT https://community.qlik.com/t5/QlikView/How-to-cap-a-number/m-p/488223#M480765 2013-11-06T17:19:45Z Re: How to cap a number https://community.qlik.com/t5/QlikView/How-to-cap-a-number/m-p/488224#M480766 <HTML><HEAD></HEAD><BODY><P>rangemin(1,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">1-fabs(actual-forecast)/actual</SPAN>)</P></BODY></HTML> Wed, 06 Nov 2013 17:25:53 GMT https://community.qlik.com/t5/QlikView/How-to-cap-a-number/m-p/488224#M480766 Gysbert_Wassenaar 2013-11-06T17:25:53Z Re: How to cap a number https://community.qlik.com/t5/QlikView/How-to-cap-a-number/m-p/488225#M480767 <HTML><HEAD></HEAD><BODY><P><BR />It works! Thank you a lot!</P></BODY></HTML> Wed, 06 Nov 2013 18:02:35 GMT https://community.qlik.com/t5/QlikView/How-to-cap-a-number/m-p/488225#M480767 2013-11-06T18:02:35Z