12 Month Rolling numbers in the script not front end

[vikasshana]

Hi,

I've the below.

Rolling:
Load * Inline [
Fiscal Period,Sales
202211,600
202212,550
202301,100
202302,200
202303,300
202304,400
202305,500
202306,600
202307,700
202308,800
202309,900
202310,1000
202311,1100
202312,1200
202401,1300

202402,1400
];

I'm looking for script in the backend to calculate the 12 Month number, expecting output as below.

Fiscal Period	Sales	12M Rolling Sales
202211	-	-
202212	-	-
202301	100	100
202302	200	300
202303	300	600
202304	400	1000
202305	500	1500
202306	600	2100
202307	700	2800
202308	800	3600
202309	900	4500
202310	1000	5500
202311	1100	6600
202312	1200	7800
202401	1300	9100
202402	1400	10400

I can achieve it in the front end by using RangeSum + above, but I want it to be implemented in the backend script so that I can store the 12 Month Rolling numbers in QVD and use the QVD in other app.

Regards,

V

[qv_testing]

It's duplicate thread - please make sure create one

https://community.qlik.com/t5/QlikView-App-Dev/12-Month-Rolling-numbers-in-the-script-rather-than-fr...