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: 
Naps_230
Contributor III
Contributor III

How to add last 6 months rolling data in month wise

Hi ,

Could you please any one guide me how to add last 12 months rolling data in month wise.

we have data 2016 to 2019 August

Dimension:- Market and Year_Month

Measure- Sales

This first table we are showing last 12 months data Month wise.

MarketSep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19
Benelux201020102010201010301020

 

So in 2nd Table we want to show Aug-2019 data should be addition of last 6 months data from 1st table.

same way other months data should be last 6 months data(That's highlighted in bold)

Right now i provided sample data only

MarketSep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19
Benelux20102010209090908010090100
1 Solution

Accepted Solutions
Brett_Bleess
Former Employee
Former Employee

See duplicate post too: https://community.qlik.com/t5/QlikView-Creating-Analytics/How-to-add-last-6-months-rolling-data-in-m...

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
Victor_Alumanah
Creator
Creator

Hi there,

See the attached file, it may be able to complete the task for you, basically i have ranked every month/year from from a certain time, loaded it into Qlikview and used it in calculating the last 6 months.

Thanks

Victor

While we teach we learn
Brett_Bleess
Former Employee
Former Employee

If Victor's post did not help fully, have a look at the following Design Blog post:

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

Here is the base link to the area as well in case you want to search around yourself for other posts that may help:

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.
Brett_Bleess
Former Employee
Former Employee

See duplicate post too: https://community.qlik.com/t5/QlikView-Creating-Analytics/How-to-add-last-6-months-rolling-data-in-m...

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.