Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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