Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlaf_93
Creator II
Creator II

cumulative sum in script area

Good evening,

i've an excel file like this:

DATE,QUANTITY,MONTH, YEAR,

01/01/2021, 10, 01,2021,

05/02/2021,50,02,2021,

06/03/2021,80,03,2021;

I would like to create in the script area a cumulative value--> 

YEAR, MONTH, QUANTITY

2021, 01, 10,

2021,02,60,

2021,03,140

 

P.S. i need to do it in the script area because i have other tables with different data field

1 Reply
Carlaf_93
Creator II
Creator II
Author

if i have a value from the previous year i want it in the sum....