topic Re: Cumulative Quantity in the script in QlikView

Cumulative Quantity in the script

Wed, 31 Oct 2012 15:02:04 GMT

Hello,

I am trying to create a cumulative total within the script and I can't recall how to do it. Essentially I want to create a new field to show the rolling total for the year, see the below example. I can do it within a chart but require it to be added as a new field in the script.

Thanks in advance,

Ralph

Week	Qty	Rolling Qty
1	30	30
2	32	62
3	45	107
4	70	177
5	31	208

Re: Cumulative Quantity in the script

CELAMBARASAN — Wed, 31 Oct 2012 15:05:09 GMT

Check with this

Load *, (Alt(Previous(RollingQty),0)+Qty) AS RollingQty;

Load * Inline [

Week,Qty

1,30

2,32

3,45

4,70

5,31];

Re: Cumulative Quantity in the script

Wed, 31 Oct 2012 15:23:43 GMT

Hello,

I get a field not found error for RollingQty. For clarity in my example I want to create the Rolling Qty field, currently I only have week and Qty.

Thanks,

Ralph

Re: Cumulative Quantity in the script

Gysbert_Wassenaar — Wed, 31 Oct 2012 15:29:03 GMT

try:

Load *, if(rowno()=1,Qty,Peek(RollingQty)+Qty) AS RollingQty

Inline [

Week,Qty

1,30

2,32

3,45

4,70

5,31];

Re: Cumulative Quantity in the script

Wed, 31 Oct 2012 15:33:20 GMT

That works brilliant.

Thanks,

Ralph

Re: Cumulative Quantity in the script

CELAMBARASAN — Wed, 31 Oct 2012 15:41:49 GMT

Hi,

Check with this

Load *, (Alt(Peek('RollingQty'),0)+Qty) AS RollingQty;

Load * Inline [

Week,Qty

1,30

2,32

3,45

4,70

5,31];