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

Running totals not working in straight table eventhough used accumulation

Hi

I have straight table with dimension as Date and expression1 as sum(sales) and expression2 as sum(sales). but the second expression I need running totals. so, I used full accumulation for second expression. but it is not working. it is showing same data as first expression. can anyone suggest me how to do this

                                                                

DateIDexpression1expression2
23/04/201313.413.41
23/04/20132379.1579.15
25/04/20133479.15158.3
26/05/201512.34160.64
31/07/201523512.65673.29
23/04/2013115423.6215423.62
25/04/201321315423.6230847.24
11/02/20153456009.7336856.97
23/04/2013456706.57706.57
08/05/20133212378.273084.84
31/07/201312390.073474.91

need output as below

                                                               

DateIDexpression2expression2
23/04/201313.413.41
23/04/20132379.1582.56
25/04/20133479.15259549.12
26/05/201512.34259549.12
31/07/201523512.65259549.12
23/04/2013115423.62245053.69
25/04/201321315423.62991558.54
11/02/20153456009.73991558.54
23/04/2013456706.571240.21
08/05/20133212378.27539775.13
31/07/201312390.075518098.033

Please can anyone suggest how to get this.

Thanks.

6 Replies
MK_QSL
MVP
MVP

Use

RangeSum(Above(YourExpression,0,RowNo()))

or

RangeSum(Above(TOTAL YourExpression,0,RowNo()))

Clever_Anjos
Employee
Employee

Accumulation only works well when you use only one dimension.

If you use more than one, please use MRKachhiaIMP solution

Anonymous
Not applicable
Author

hi Amelia D

                  =sum(expression1)  or =sum(expression2)   give both expressions on stright table give total sum in below

Not applicable
Author

Thanks. I have used this but this is not working. expression2 showing same as expression1

MK_QSL
MVP
MVP

Provide your sample app with dummy data..

Anonymous
Not applicable
Author

hi