topic Accumulation in a Pivot table in QlikView https://community.qlik.com/t5/QlikView/Accumulation-in-a-Pivot-table/m-p/924669#M468101 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>I want to build an expression where I can see the accumulated sum of one field. I started with an RangeSum function and everthing looks fine but on the second view I saw that when I click on a date the accumulation will start from the beginning. Is there a possibility to create a function which gives back the "total" accumulation when I click on a specific date.</P><P></P><P>Please look at my example...</P><P></P><P>Thank you!</P><P></P><P>PS. My goal is to build a function in the frontend and not in the script enviroment.</P></BODY></HTML> Wed, 23 Sep 2015 13:03:05 GMT 2015-09-23T13:03:05Z Accumulation in a Pivot table https://community.qlik.com/t5/QlikView/Accumulation-in-a-Pivot-table/m-p/924669#M468101 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P></P><P>I want to build an expression where I can see the accumulated sum of one field. I started with an RangeSum function and everthing looks fine but on the second view I saw that when I click on a date the accumulation will start from the beginning. Is there a possibility to create a function which gives back the "total" accumulation when I click on a specific date.</P><P></P><P>Please look at my example...</P><P></P><P>Thank you!</P><P></P><P>PS. My goal is to build a function in the frontend and not in the script enviroment.</P></BODY></HTML> Wed, 23 Sep 2015 13:03:05 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-a-Pivot-table/m-p/924669#M468101 2015-09-23T13:03:05Z Re: Accumulation in a Pivot table https://community.qlik.com/t5/QlikView/Accumulation-in-a-Pivot-table/m-p/924670#M468102 <HTML><HEAD></HEAD><BODY><P>I cannot see your qvw (as I am working with Personal Edition), but try something like this:</P><P></P><P><STRONG>If(Sum(Sales) &gt; 0, RangeSum(Above(TOTAL Sum({&lt;DateField = &gt;}Sales), 0, RowNo(TOTAL))))</STRONG></P></BODY></HTML> Wed, 23 Sep 2015 13:05:43 GMT https://community.qlik.com/t5/QlikView/Accumulation-in-a-Pivot-table/m-p/924670#M468102 sunny_talwar 2015-09-23T13:05:43Z