topic Re: how to calculate a running sum in a script in QlikView

how to calculate a running sum in a script

Tue, 23 Jul 2013 07:06:01 GMT

Hi I have an doubt please any one help me with this..?

my table look like this

Table1 :

load a,b from somewhere

Table 2 :

load c from somewhere

now i created an chart :

I write an two expression a.sum(C) and b.rangesum(sum(C),above(column(2)))

A	B	sum(C)	rangesum(sum(C),above(column(2)))
mumbai	xyz	5	5
chennai	abc	11	16
delhi	ijk	12	28
shimla	lmn	2	30
kerala	pqr	6	36

but now I want to write expression running total in script.Please anyone help me with this..?

Tue, 23 Jul 2013 07:09:48 GMT

try this example in script

Data:

LOAD

Date,

installs as install_new,

NUMSUM(installs, PEEK('installs', -1)) AS installs;

LOAD * INLINE [

Date , installs

01/01/2011 , 5

02/01/2011 , 4

03/01/2011 , 2

04/01/2011 , 3

05/01/2011 , 2

06/01/2011 , 1

07/01/2011 , 8

08/01/2011 , 5

09/01/2011 , 3

];

Tue, 23 Jul 2013 07:14:52 GMT

try this

load

C as C_new,

NUMSUM(C, PEEK('C', -1)) AS C

table;