topic Re: Cumulate Column in QlikView

Cumulate Column

Fri, 16 Oct 2015 21:08:39 GMT

Hello,

I have one column (dimension) Year and in the rows i have the months e.g.

2015 cum. 2014 cum.

oct 10 100 50 140

sept 20 90 40 90

aug 30 70 30 50

jul 40 40 20 20

what is the formula for the cumulate column?

Fri, 16 Oct 2015 21:17:46 GMT

Just copy the formula you use for 2015 and check the full accumulation box in the expression properties.

See attached

swuehl — Fri, 16 Oct 2015 23:21:55 GMT

You can use chart inter record functions like above() or below() in combination with rangesum().

Something like

=Rangesum( Above( Sum( ValueField), 0, RowNo() )

Rangesum(Below(Sum(TypeID),0,NoOfRows() ))

[depending on month sort order]

Anonymous — Sun, 18 Oct 2015 05:26:17 GMT

Hi ,

Here is the attached QVW .

with both accumulation function in Straight table and Range sum in Pivot table .

I think this helps .

Thanks,

Bunny