topic How Can I calculate percentage Change in Graph? in QlikView https://community.qlik.com/t5/QlikView/How-Can-I-calculate-percentage-Change-in-Graph/m-p/336571#M573390 <HTML><HEAD></HEAD><BODY><P>Hi community,&nbsp; </P><P></P><P>I have a line graph with values of a field on various dates.&nbsp; How can I calculate the percentage change on the dates from the previous date instead?&nbsp; The dates are the month.&nbsp; Example:&nbsp; I have a value of 500 for the stock in march and 600 in april.&nbsp; I want the percentage change of 600-500/500 or 20% for April in the line graph rather than 600.</P><P></P><P>Any ideas?</P></BODY></HTML> Thu, 05 Jul 2012 16:39:21 GMT 2012-07-05T16:39:21Z How Can I calculate percentage Change in Graph? https://community.qlik.com/t5/QlikView/How-Can-I-calculate-percentage-Change-in-Graph/m-p/336571#M573390 <HTML><HEAD></HEAD><BODY><P>Hi community,&nbsp; </P><P></P><P>I have a line graph with values of a field on various dates.&nbsp; How can I calculate the percentage change on the dates from the previous date instead?&nbsp; The dates are the month.&nbsp; Example:&nbsp; I have a value of 500 for the stock in march and 600 in april.&nbsp; I want the percentage change of 600-500/500 or 20% for April in the line graph rather than 600.</P><P></P><P>Any ideas?</P></BODY></HTML> Thu, 05 Jul 2012 16:39:21 GMT https://community.qlik.com/t5/QlikView/How-Can-I-calculate-percentage-Change-in-Graph/m-p/336571#M573390 2012-07-05T16:39:21Z Re: How Can I calculate percentage Change in Graph? https://community.qlik.com/t5/QlikView/How-Can-I-calculate-percentage-Change-in-Graph/m-p/336572#M573392 <HTML><HEAD></HEAD><BODY><P>Try something like</P><P></P><P><EM>=sum(Stock)/<STRONG>above</STRONG>(sum(Stock)) -1</EM></P><P></P><P>i.e. reference the expression value in the context of the previous dimension value using above() function.<EM><BR /></EM></P></BODY></HTML> Thu, 05 Jul 2012 16:56:32 GMT https://community.qlik.com/t5/QlikView/How-Can-I-calculate-percentage-Change-in-Graph/m-p/336572#M573392 swuehl 2012-07-05T16:56:32Z