topic Re: Cumulative sum in QlikView

Cumulative sum

Thu, 10 Oct 2013 09:33:20 GMT

Hi Community,

PFA

how to calculate cumulative sum..

Thanks in Advance

Gysbert_Wassenaar — Thu, 10 Oct 2013 09:41:49 GMT

You can calculate it in the script like this:

Table:

LOAD [customer Id],

product,

D.O.P,

[Bill Amount],

Region,

rangesum([Bill Amount],peek('Cumulative')) as Cumulative

FROM

comm95418.xlsx

(ooxml, embedded labels, table is Sheet1);

If you want to do it with an expression in a chart you can use rangesum(above(total sum([Bill Amount]),0,RowNo(total)))

Thu, 10 Oct 2013 09:52:20 GMT

for straight table u can use accumulation in expression tab.

use rangesum and above functions

rangesum(above(total sum({1}Amount),0,3))

sudeepkm — Thu, 10 Oct 2013 09:58:37 GMT

As Aryabrahma mentioned you can use the Full accumulation in the Chart Expression properties. As shown below.