Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kiranpatil123
Contributor III
Contributor III

Rolling 12 months for each month in Backend script

Hi Qlik experts ,

I could require you help on Rolling 12 months for each month done in Backend script.

For each Month take previous 12 months and then take sum of it and store it in that particular month ( may be by for loop )

PFA , it explained in detailed and the data is provided

It will be great if some 1 does in it qvw and upload it  

Advance Thanks

1 Solution

Accepted Solutions
rubenmarin

3 Replies
rubenmarin

kiranpatil123
Contributor III
Contributor III
Author

Thanks its working

May i know how we can do in Front end also 

 

rubenmarin

In front end, in a table with Date and sum, and sorted by Date this expresion can work:

RangeSum(Above(TOTAL sum,0,12))

But note that in front end selections, sort order of table, moving dimensions... can return different results.

To return a stable value there are another solutions like the A-Of Table: https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130