topic Itterative Sum in QlikView

Itterative Sum

Tue, 08 Oct 2013 22:46:10 GMT

I want to load to do following Sum

Inital Value = 20

ColumnA ColumnB Value

Jan 20 40 //Value is ColumnB+Initial Value

Feb 30 70 //Value is 40 from above + Column B

Mar 10 80 //Value is 70 from above + Column B

Apr 40 120 //Value is 80 from above + Column B

May 20 140 //Value is 120 from above + Column B

How do I do it? I have ColumnA and ColumnB Loaded, but I want to build the Value Column using sum logic mentioned above.

swuehl — Tue, 08 Oct 2013 22:50:59 GMT

Maybe try something along these lines:

LOAD *,

rangesum(if(recno() = 1,20,peek(Value)),ColumnB) as Value

INLINE [

ColumnA, ColumnB

Jan, 20

Feb, 30

Mar, 10

Apr, 40

May, 20

];

Clever_Anjos — Tue, 08 Oct 2013 22:53:13 GMT

LET InitialValue=20;

LOAD

ColumnA,

ColumnB,

if(IsNull(Peek('Value')),

ColumnB + $(InitialValue),

rangesum(Peek('Value'),ColumnB)

) as Value

;

LOAD * INLINE [

ColumnA, ColumnB

Jan, 20

Feb, 30

Mar, 10

Apr, 40

May, 20

];