topic Accumulation in charts in QlikView https://community.qlik.com/t5/QlikView/Accumulation-in-charts/m-p/983711#M335748 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an issue regarding a chart. It's about accumulation values. (see the picture )</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98155_Capture.JPG" style="height: 408px; width: 620px;" /></P><P>In this chart I have, opened cases, closed cases and remaining cases. The orange line is remaining cases with Accumulation = 2 and the yellow line is with no accumulation.</P><P></P><P>My goal values are these: (the formula is Opened Cases + Remaining cases from previous month - closed cases)</P><P>01/2015 = 292;</P><P>02/2015 = 2012 + 292 - 1596 =708;</P><P>03/2015 = 2152 + 708 - 1648 = 1212;</P><P>04/2015 = 2056 + 1212 - 1602 = 1666;</P><P>05/2015 = 2181 + 1666 - 1650 = 2197;</P><P>06/2015 = 2241 + 2197 - 3332 = 1106;</P><P>07/2015 = 1305 + 1106 - 1069 = 1342;</P><P></P><P>You can see that for the first two months the values are correct.</P><P>I've tried with full accumulation but the values after 05/2015 are wrong. </P><P></P><P>Can you give me an idea how can I do this ?</P><P></P><P>Thanks ! </P></BODY></HTML> Mon, 07 Sep 2015 06:33:04 GMT 2015-09-07T06:33:04Z Accumulation in charts https://community.qlik.com/t5/QlikView/Accumulation-in-charts/m-p/983711#M335748 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have an issue regarding a chart. It's about accumulation values. (see the picture )</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98155_Capture.JPG" style="height: 408px; width: 620px;" /></P><P>In this chart I have, opened cases, closed cases and remaining cases. The orange line is remaining cases with Accumulation = 2 and the yellow line is with no accumulation.</P><P></P><P>My goal values are these: (the formula is Opened Cases + Remaining cases from previous month - closed cases)</P><P>01/2015 = 292;</P><P>02/2015 = 2012 + 292 - 1596 =708;</P><P>03/2015 = 2152 + 708 - 1648 = 1212;</P><P>04/2015 = 2056 + 1212 - 1602 = 1666;</P><P>05/2015 = 2181 + 1666 - 1650 = 2197;</P><P>06/2015 = 2241 + 2197 - 3332 = 1106;</P><P>07/2015 = 1305 + 1106 - 1069 = 1342;</P><P></P><P>You can see that for the first two months the values are correct.</P><P>I've tried with full accumulation but the values after 05/2015 are wrong. </P><P></P><P>Can you give me an idea how can I do this ?</P><P></P><P>Thanks ! </P></BODY></HTML> Mon, 07 Sep 2015 06:33:04 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-charts/m-p/983711#M335748 2015-09-07T06:33:04Z Re: Accumulation in charts https://community.qlik.com/t5/QlikView/Accumulation-in-charts/m-p/983712#M335749 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can u attach the qvw file it will be easy to help you out.</P></BODY></HTML> Mon, 07 Sep 2015 06:37:08 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-charts/m-p/983712#M335749 2015-09-07T06:37:08Z Re: Accumulation in charts https://community.qlik.com/t5/QlikView/Accumulation-in-charts/m-p/983713#M335750 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>try with accumulation=7</P></BODY></HTML> Mon, 07 Sep 2015 07:18:51 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-charts/m-p/983713#M335750 prajapatiamar38 2015-09-07T07:18:51Z