topic Re: accumulated Sum in QlikView

accumulated Sum

rohit214 — Tue, 01 Apr 2014 07:17:13 GMT

Hi All,

I have a table and i want the result shown below

Data Table

Required Output

Thanks

Rohit

Re: accumulated Sum

MK_QSL — Tue, 01 Apr 2014 07:26:01 GMT

Create a straight Table

Dimension = Bucket

Expression

SUM(No.)

and

SUM({1}TOTAL No.)-RangeSum(ABOVE(SUM(No.),1,RowNo()))

Hope this helps...

UPDATE:

There is another option..

RangeSum(Below(SUM(No.),0,Max(TOTAL Aggr(RowNo(),Bucket))))

Re: accumulated Sum

brijesh1991 — Tue, 01 Apr 2014 07:46:54 GMT

PFA qvw

Re: accumulated Sum

kangaroomac — Tue, 01 Apr 2014 08:12:35 GMT

Hiya,

If you would like to add the other field (No.) as well, you'll have to do it in the expression (with no aggregation), not as a dimension (else the first value 347 will be copied all the way down).

I've attached a QV Sample.

Re: accumulated Sum

Tue, 01 Apr 2014 08:16:19 GMT

I can not see your input data, but what do you think about using Accumulation property? (Properties/Expression tab - under expression list).

regards

Darek

Re: accumulated Sum

rohit214 — Tue, 01 Apr 2014 08:39:24 GMT

Thanks to all

Regards

Rohit