Qlik Community

New to Qlik Sense

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
asinghal0412
Partner
Partner

Cumalative/running total

Dear Qlik Community,

I have a table below,

Calendar Year/MonthNew & CarryoverNet VAVE (Calculated)Cummalative Net Vave
Jan 2021 Actualsingle : Carryover373 M¥0
Jan 2021 Actualsingle : New64 M¥0
Feb 2021 Actualsingle : Carryover359 M¥0
Feb 2021 Actualsingle : New78 M¥0
Mar 2021 Actualsingle : Carryover358 M¥0
Mar 2021 Actualsingle : New161 M¥0
Apr 2021 Actualsingle : Carryover365 M¥0
Apr 2021 Actualsingle : New155 M¥0
May 2021 Forecastsingle : Carryover80 M¥0
May 2021 Forecastsingle : New122 M¥0
Jun 2021 Forecastsingle : Carryover72 M¥0
Jun 2021 Forecastsingle : New155 M¥0
Jul 2021 Forecastsingle : Carryover63 M¥0
Jul 2021 Forecastsingle : New179 M¥0
Aug 2021 Forecastsingle : Carryover58 M¥0
Aug 2021 Forecastsingle : New149 M¥0
Sep 2021 Forecastsingle : Carryover44 M¥0
Sep 2021 Forecastsingle : New198 M¥0
Oct 2021 Forecastsingle : Carryover29 M¥0
Oct 2021 Forecastsingle : New203 M¥0
Nov 2021 Forecastsingle : Carryover11 M¥0
Nov 2021 Forecastsingle : New224 M¥0
Dec 2021 Forecastsingle : Carryover0 M¥0
Dec 2021 Forecastsingle : New207 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
MayilVahanan

Hi @asinghal0412

Try like below

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

o/p:

MayilVahanan_0-1621500378566.png

 

Thanks & Regards,
Mayil Vahanan R
asinghal0412
Partner
Partner
Author

I tried your code, It gives an error message.

Did you change the 3rd column as well?

Akash

MayilVahanan

HI @asinghal0412 

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