# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Partner

## Cumalative/running total

Dear Qlik Community,

I have a table below,

 Calendar Year/Month New & Carryover Net VAVE (Calculated) Cummalative Net Vave Jan 2021 Actual single : Carryover 373 M¥ 0 Jan 2021 Actual single : New 64 M¥ 0 Feb 2021 Actual single : Carryover 359 M¥ 0 Feb 2021 Actual single : New 78 M¥ 0 Mar 2021 Actual single : Carryover 358 M¥ 0 Mar 2021 Actual single : New 161 M¥ 0 Apr 2021 Actual single : Carryover 365 M¥ 0 Apr 2021 Actual single : New 155 M¥ 0 May 2021 Forecast single : Carryover 80 M¥ 0 May 2021 Forecast single : New 122 M¥ 0 Jun 2021 Forecast single : Carryover 72 M¥ 0 Jun 2021 Forecast single : New 155 M¥ 0 Jul 2021 Forecast single : Carryover 63 M¥ 0 Jul 2021 Forecast single : New 179 M¥ 0 Aug 2021 Forecast single : Carryover 58 M¥ 0 Aug 2021 Forecast single : New 149 M¥ 0 Sep 2021 Forecast single : Carryover 44 M¥ 0 Sep 2021 Forecast single : New 198 M¥ 0 Oct 2021 Forecast single : Carryover 29 M¥ 0 Oct 2021 Forecast single : New 203 M¥ 0 Nov 2021 Forecast single : Carryover 11 M¥ 0 Nov 2021 Forecast single : New 224 M¥ 0 Dec 2021 Forecast single : Carryover 0 M¥ 0 Dec 2021 Forecast single : New 207 M¥ 0

In the last column, I am trying to get the cumulative total of the 3rd column.

My current code is:

RangeSum(Above(TOTAL Sum([Net VAVE (Calculated)]), 1, RowNo(TOTAL)))

but as you can see in the table the values are zero.

Can any1 help me with the code?

Thanks,

Akash

3 Replies
MVP

Try like below

RangeSum(Above(Total Sum([Net VAVE (Calculated)]),0, RowNo(Total)))

o/p:

Thanks & Regards,
Mayil Vahanan R
Partner
Author

I tried your code, It gives an error message.

Did you change the 3rd column as well?

Akash

MVP

Instead of "Sum([Net VAVE (Calculated)])", you can change use ur expression.

If it still shows error, pls provide the sample file

Thanks & Regards,
Mayil Vahanan R
Tags
Community Browser