Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

QlikView App Dev

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now

Who Me Too'd this topic

Antoine5531
Contributor II
Contributor II

Cumulative sum by month in load

Hello,

I'm trying to add a variable to my data that would sum the values of all the previous month of this year + the actual month.

Here is an example :

YearMonthidAmountNew variable
202101a1010
202102b1020
202103c1050
202103d1050
202103e1050
202104f1060
202105g1080
202105h1080
202106i1090

 

I manage to do it in a table but i'm struggling to do it in the script pls help.

Thanks.

 

Labels (2)
Who Me Too'd this topic