topic Re: Accumulation Problem in QlikView https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753769#M268587 <HTML><HEAD></HEAD><BODY><P>Dear Anbu,</P><P></P><P>I'm using Pivot table... Thnx for ur reply...</P></BODY></HTML> Sun, 16 Nov 2014 08:23:14 GMT 2014-11-16T08:23:14Z Accumulation Problem https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753764#M268582 <HTML><HEAD></HEAD><BODY><P><IMG alt="Accumulation.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/71347_Accumulation.JPG.jpg" style="width: 620px; height: 547px;" /></P><P>Dear All,</P><P></P><P>I'm new in qlikview..In my qlikview accumulation option is disable in "Expression" TAB. How can i enable accumulaiton option.</P><P></P><P>Thanks,</P><P></P><P>Masba</P></BODY></HTML> Sun, 16 Nov 2014 07:11:09 GMT https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753764#M268582 2014-11-16T07:11:09Z Re: Accumulation Problem https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753765#M268583 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you post sample application to look over.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Sun, 16 Nov 2014 07:15:58 GMT https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753765#M268583 ashfaq_haseeb 2014-11-16T07:15:58Z Re: Accumulation Problem https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753766#M268584 <HTML><HEAD></HEAD><BODY><P>Accumulation is not available in Pivot, Gauge chart etc. Which chart are you using?</P></BODY></HTML> Sun, 16 Nov 2014 07:17:02 GMT https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753766#M268584 anbu1984 2014-11-16T07:17:02Z Re: Accumulation Problem https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753767#M268585 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can also achieve an aggregation by using the rangesum() function together with a inter record function such as above().</P><P></P><P>rangesum(above(sum(Value),0,rowno()))</P><P></P><P>This will add upp all values from 0 to the current row.</P><P></P><P>In a pivot table it can quickly get tricky though depending on how you structure the pivot table.</P></BODY></HTML> Sun, 16 Nov 2014 07:31:49 GMT https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753767#M268585 morgankejerhag 2014-11-16T07:31:49Z Re: Accumulation Problem https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753768#M268586 <HTML><HEAD></HEAD><BODY><P>See this document for some alternatives: <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4252" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7;">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Sun, 16 Nov 2014 07:55:32 GMT https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753768#M268586 Gysbert_Wassenaar 2014-11-16T07:55:32Z Re: Accumulation Problem https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753769#M268587 <HTML><HEAD></HEAD><BODY><P>Dear Anbu,</P><P></P><P>I'm using Pivot table... Thnx for ur reply...</P></BODY></HTML> Sun, 16 Nov 2014 08:23:14 GMT https://community.qlik.com/t5/QlikView/Accumulation-Problem/m-p/753769#M268587 2014-11-16T08:23:14Z