Calculate last 12 months Rolling Total in backend Script

[Hemachandran1]

Hi Team,

I have sales amount field, in that i need to calculate last 12 months value to each month. 

I have attached the sample data

For 2023 Jan I need the Rolling Month value for last 12 months..

Need  it on the Backend Script..

Thanks

[anat]

you can try using As of Table concept:

https://community.qlik.com/t5/Design/The-As-Of-Table/ba-p/1466130

or 

https://community.qlik.com/t5/New-to-Qlik-Sense/Rolling-12-Months-in-Load-Script/td-p/2124107