How to load year to date sales into script from excel data?

[#1]

Hello Dears,

I have to load the year to date sales from the data in TestData.xlsx into the scripting itself.

In the Qlikview document, I have been able to calculate and display the year to date sales in a textbox when user clicks on PeriodCounter. However, i need to be able to load year to date sales in the scripting itself as follows:

DataTable:

LOAD Year,
Month,
YearMonth,
PeriodCounter,
Country,
Supplier,
Item,
Sales//,
//YearToDate for Sales here
FROM

(ooxml, embedded labels, table is Sheet1);

Or i could use the loaded data above from DataTable above to load another table in the script with same list of columns and then calculate the YearToDate sales in a for loop or using any algorithm. But it needs to be loaded in the script itself if possible as a table with the other columns

Please find attached the test data and my qlikview application. Any help appreciated , thanks

[#2]

I tried this and it is indeed being loaded the cumulated year to date values for each year in the scripting portion of the application during the load.

yoohooooo THat's great work! Thanks lots Aaron

[#3]

Thanks James for your help i will also look into this as an additional solution proposal for the client

you guys are so great at QLikview