topic CAGR calculation in QlikView https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819453#M1027969 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I got stuck in showing CAGR values in Bar chart.</P><P></P><P>I have Year and product type as dimensions,Revenue value in $M and have to show CAGR(2011-2014) and CAGR(2014-2018).</P><P></P><P>I am trying to use bar chart here.</P><P></P><P>Could any one help to get this in Bar chart? Is this possible or is there anyother way to show these values.</P><P></P><P>Thanks</P><P>Sunil</P></BODY></HTML> Tue, 03 Mar 2015 07:24:28 GMT cmsunilkumar 2015-03-03T07:24:28Z CAGR calculation https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819453#M1027969 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I got stuck in showing CAGR values in Bar chart.</P><P></P><P>I have Year and product type as dimensions,Revenue value in $M and have to show CAGR(2011-2014) and CAGR(2014-2018).</P><P></P><P>I am trying to use bar chart here.</P><P></P><P>Could any one help to get this in Bar chart? Is this possible or is there anyother way to show these values.</P><P></P><P>Thanks</P><P>Sunil</P></BODY></HTML> Tue, 03 Mar 2015 07:24:28 GMT https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819453#M1027969 cmsunilkumar 2015-03-03T07:24:28Z Re: CAGR calculation https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819454#M1027970 <HTML><HEAD></HEAD><BODY><P>Can you provide some sample data or sample apps please?</P></BODY></HTML> Tue, 03 Mar 2015 07:35:58 GMT https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819454#M1027970 MK_QSL 2015-03-03T07:35:58Z Re: CAGR calculation https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819455#M1027971 <HTML><HEAD></HEAD><BODY><P>CAGR = (pow(Column(2)/Column(9),(1/4))-1)</P><P></P><P>to calculate 4 yrs cagr&nbsp; col(2) will be current yr sale and col(9) with last three yrs sale </P><P></P><P>HTH</P><P></P><P>Vikas</P></BODY></HTML> Tue, 03 Mar 2015 07:36:04 GMT https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819455#M1027971 vikasmahajan 2015-03-03T07:36:04Z Re: CAGR calculation https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819456#M1027972 <HTML><HEAD></HEAD><BODY><P>HAVE YOU GOT CAGR ?? STILL ANY CLEARIFICATION</P><P></P><P>VIKAS</P></BODY></HTML> Mon, 09 Mar 2015 09:27:38 GMT https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819456#M1027972 vikasmahajan 2015-03-09T09:27:38Z Re: CAGR calculation https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819457#M1027973 <HTML><HEAD></HEAD><BODY><P>Yes....i am facing some issue.</P><P></P><P>do you want me to first add column 2 and column 9?</P><P></P><P>can you please tell me the expression to calcuate CAGR for 2013-2012 when my selection is 2014?</P></BODY></HTML> Mon, 09 Mar 2015 09:38:10 GMT https://community.qlik.com/t5/QlikView/CAGR-calculation/m-p/819457#M1027973 cmsunilkumar 2015-03-09T09:38:10Z