topic Commulative Sum in QlikView

Commulative Sum

Tue, 27 Dec 2011 06:52:49 GMT

Hi Guys,

Need your help again.

Please see my table below:

Output Table:

PO NO	ITEM NO	QTY	QTY Commulative
PO-10001	ITEM-01	10	10
PO-10002	ITEM-01	15	25
PO-10003	ITEM-02	20	20
PO-10004	ITEM-02	10	10

QTY Commulative is the Commulative Sum of QTY group by ITEM NO.

Thank you..

~skip~

Anonymous — Tue, 27 Dec 2011 07:05:19 GMT

Hey Skip,

Here's one way of sorting it out using Peek() to determine when the ITEMNO value changes:

Load

PONO,

ITEMNO,

QTY,

if(peek('ITEMNO')<>ITEMNO, QTY, peek('QTY_Cumulative')+QTY) as QTY_Cumulative;

LOAD * INLINE [

PONO, ITEMNO, QTY

PO-10001, ITEM-01, 10

PO-10002, ITEM-01, 15

PO-10003, ITEM-02, 20

PO-10004, ITEM-02, 10

];

Tue, 27 Dec 2011 07:12:23 GMT

Hi Johannes,

Thank you very much, simply and exactly what I need.

Regards,

~skip~