topic Cumulative Sum of amount based on id & path id in QlikView

Cumulative Sum of amount based on id & path id

ashishbhuyekar — Thu, 17 May 2018 15:40:54 GMT

Hi All,

I have data like below, Can anyone suggest how I can achieve output below? basically it's sum of amount w.r.t. path and Id.

Please help on this.

Output-

YoussefBelloum — Thu, 17 May 2018 15:45:45 GMT

Hi,

try this:

=RangeSum(Above(Amount,0,rowno()))

jaumecf23 — Thu, 17 May 2018 15:56:00 GMT

Hi,

You can do something like this in your script:

Table1:

LOAD if(Peek(Id)=Id,Amount+Peek(AmountAcumulated),Amount) as AmountAcumulated,

* INLINE [

Id, Path, Amount

1, 6, 1000

1, 12, 1000

1, 18, 2000

1, 24, 1000

2, 6, 1000

2, 12, 2000

2, 18, 0

2, 24, 0

3, 6, 1000

3, 12, 3000

3, 18, 1000

3, 24, 0

];

ashishbhuyekar — Thu, 17 May 2018 16:22:43 GMT

Brilliant Jaume Criballés Faja ! Thanks a lot for quick solution.

shiveshsingh — Thu, 17 May 2018 16:59:01 GMT

Try this as your expression

=if(Id=Above(Id),RangeSum(Above(sum(Amount),0,RowNo(TOTAL))),sum(Amount))