Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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