Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rohit214
Creator III
Creator III

accumulated Sum


Hi All,

I have a table and i want the result shown below

Data Table

Capture.PNG

Required Output

required.PNG

Thanks

Rohit

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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))))

View solution in original post

5 Replies
MK_QSL
MVP
MVP

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))))

View solution in original post

brijesh1991
Partner
Partner


PFA qvw

kangaroomac
Partner
Partner

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.

Test2.png

Not applicable

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

regards

Darek

rohit214
Creator III
Creator III
Author

Thanks to all

Regards

Rohit