topic Re: How to calculate Growth rate in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453580#M169245 <HTML><HEAD></HEAD><BODY><P>that is mathematic;)</P><P>we can help you if you simply tell us what value you want it to be (growth rate)</P></BODY></HTML> Thu, 24 Jan 2013 13:53:28 GMT 2013-01-24T13:53:28Z How to calculate Growth rate https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453579#M169244 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How to calculate growth rate? </P><P></P><P>Scenario 1 :</P><P></P><P>EBIDTA 2012 : 350</P><P>EBIDTA 2011 : 370</P><P></P><P>Growth_rate = ((vPeriod / vPrevPeriode) -1) * 100&nbsp; = ((370/ 350)-1)*100 = +5.71%</P><P></P><P>Scenario 2 :</P><P>EBIDTA 2010 : -2</P><P>EBIDTA 2011 : 350</P><P></P><P>Growth_rate = ((vPeriod / vPrevPeriode) -1) * 100&nbsp; = ((350/ -2)-1)*100 = <SPAN style="color: #ff0000;">-17600 %&amp;$ WTF</SPAN></P><P></P><P><SPAN style="color: #000000;">How can i calculate growth rate where the previous ( or current) period is negative?</SPAN></P><P></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P>Dror</P></BODY></HTML> Thu, 24 Jan 2013 11:53:19 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453579#M169244 2013-01-24T11:53:19Z Re: How to calculate Growth rate https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453580#M169245 <HTML><HEAD></HEAD><BODY><P>that is mathematic;)</P><P>we can help you if you simply tell us what value you want it to be (growth rate)</P></BODY></HTML> Thu, 24 Jan 2013 13:53:28 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453580#M169245 2013-01-24T13:53:28Z Re: How to calculate Growth rate https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453581#M169246 <HTML><HEAD></HEAD><BODY><P>I would agree with <A href="http://mathforum.org/library/drmath/view/55720.html">this </A>opinion, calculating percentage change with numbers having different signs is not really meaningful. But read on for some possible approaches.</P><P></P><P>Or have a look at:</P><P><A class="loading active_link" href="http://mathematics.blurtit.com/q914612.html" title="http://mathematics.blurtit.com/q914612.html">http://mathematics.blurtit.com/q914612.html</A></P><P></P><P>(an approach which I personally wouldn't apply).</P><P></P><P>Regards,</P><P>Stefan</P></BODY></HTML> Thu, 24 Jan 2013 14:18:50 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453581#M169246 swuehl 2013-01-24T14:18:50Z Re: How to calculate Growth rate https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453582#M169247 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P></P><P>I've eventually used the following formula:</P><P></P><P><SPAN style="color: #1f497d; text-decoration: underline;">&nbsp;&nbsp; (nieuw – oud)__</SPAN><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp; X 100% </SPAN></P><P><SPAN style="color: #1f497d;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fabs(Oud)</SPAN></P><P></P><P>I wasn't really happy about this solution but the client was <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Fri, 25 Jan 2013 08:44:22 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453582#M169247 2013-01-25T08:44:22Z Re: How to calculate Growth rate https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453583#M169248 <HTML><HEAD></HEAD><BODY><P>personalny i prefer solution that:</P><P></P><P>- if old value is below zero (EBIDTA 2010 : &lt;0)</P><P>and new value is above zero (EBIDTA 2011 : &gt;0)</P><P></P><P>my growth rate is allways equal 100%</P><P>but if Your client is happy... that is good;)</P></BODY></HTML> Fri, 25 Jan 2013 09:52:10 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-Growth-rate/m-p/453583#M169248 2013-01-25T09:52:10Z