Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

accumulated calculations problem

I’m having some problem with accumulated calculations

In the table below you can see the outcome of the accumulated calculation by checking the “full accumulation” check box in the expression.

I need the accumulation calculation to be in the other way,

From the bottom to the top.

When I change the sorting, the accumulation calculation is changed, but then I have the latest date at the bottom and I like to have3it on the top.

C_Date

A_Accumulated

A

7/23/2013

3,796

3,796

7/22/2013

7,381

3,585

7/21/2013

11,278

3,897

7/20/2013

16,582

5,304

7/19/2013

33,371

16,789

7/18/2013

36,443

3,072

7/17/2013

39,595

3,152

7/16/2013

42,783

3,188

7/15/2013

46,015

3,232

7/14/2013

49,272

3,257

7/13/2013

52,588

3,316

07/12/2013

55,996

3,408

07/11/2013

59,762

3,766

07/10/2013

64,799

5,037

07/09/2013

69,634

4,835

07/08/2013

74,001

4,367

07/07/2013

77,504

3,503

07/06/2013

80,660

3,156

07/05/2013

83,828

3,168

07/04/2013

87,098

3,270

07/03/2013

90,422

3,324

07/02/2013

94,004

3,582

07/01/2013

97,570

3,566

Thanks in advance.

2 Replies
er_mohit
Master II
Master II

try this

Updated By me If You have More than one dimension then

aggr(rangesum(above(sum(Fieldname),0,rowno())),C_Date)

Not applicable
Author

nope.

but it helped.

Sum (total A) - rangesum(above(sum(A),0,rowno())))

Somthing like that.

Thanks.