Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
AmirKilkr
Contributor
Contributor

Accumulation

Hello,

 

I am trying to write an accumulation script but I am unable to succeed.

May you assist me, please?

AmirKilkr_0-1645557202264.png

 

SalesAggFinal:

LOAD
YearMonth,
"Group",
Quantity,
TotalPriceBeforVat,
TotalPriceBeforVat/Quantity as unitprice
FROM [lib://DB/SalesAggFinal.qvd]

(qvd);

SalesAggAcc:

LOAD "Group",
YearMonth,
TotalPriceBeforVat, RangeSum(peek('Cumulative') , TotalPriceBeforVat) AS TotalPriceBeforVatCumulative

Resident SalesAggFinal;
exit script

Before:

AmirKilkr_2-1645557682270.png

 

After:

AmirKilkr_1-1645557580039.png

 

What do I need to do?\

 

Labels (2)
0 Replies