Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatbza
Creator
Creator

How to calculate last 12 months for the selected month

Hello All,

I want show the data for last 12 months for each month.

For example I have a columns like "Month-Year" and "Value"  like below table, and for Jan-2018 it needs to show the sum of last 12 months(means Feb-2017 to Jan-2018) values, like this for all months need to show the some of last 12 months from that month.

Month-YearValuesum of value for last 12 months for each month
Jan-201810 
Feb-201830 
Mar-201850 
Apr-2018100 
May-2018200 
Jun-201840 
Jul-201850 
Aug-201860 
Sep-201875 
Oct-201896 
Nov-201877 
Dec-201845 
Jan-201998 
Feb-201978 
Mar-201965 
Apr-201990 
May-201980 
Jun-201977 
Jul-201967 
Aug-201956 
Sep-201998 
Oct-201923 
Nov-201943 
Dec-201955 
1 Solution

Accepted Solutions
Brett_Bleess
Former Employee
Former Employee

If either of the existing posts helped you with your use case, be sure to return to the thread and use the Accept as Solution button on the one(s) that did help.  This gives the posters credit for the assistance and lets other Community Members know what actually worked for you.

The only thing I have in addition to what they posted is a specific Design Blog post that may help with this use case, and then I am including the base URL to the area too in case you wish to further search for things yourself:

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

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

3 Replies
manoranjan_d
Specialist
Specialist

RangeSum(Above(Value,0,12))

or this

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

Kushal_Chawda

if you want to calculate it via script flag method. follow below post

https://community.qlik.com/t5/QlikView-Documents/Rolling-N-months/ta-p/1484325

Brett_Bleess
Former Employee
Former Employee

If either of the existing posts helped you with your use case, be sure to return to the thread and use the Accept as Solution button on the one(s) that did help.  This gives the posters credit for the assistance and lets other Community Members know what actually worked for you.

The only thing I have in addition to what they posted is a specific Design Blog post that may help with this use case, and then I am including the base URL to the area too in case you wish to further search for things yourself:

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

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.