Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nancymarmat
Contributor II
Contributor II

Moving Annual Total (MAT) by week

Is  it possible to calculate the Moving Annual Total (MAT) by week, rather than by month?

I did find an example that calculates MAT by month for a given year/12 month period, but I need it  based on 52 weeks.

Thank you for any insight.

1 Reply
Brett_Bleess
Former Employee
Former Employee

So you need to swap the months for weeks to make that happen...  Not sure what you are really asking and I am sure others are not either as it is as simple as changing the month to weeks in the calculations in the example you found.  If we are missing something, please leave a further update with more details on what you need.  You will of course need weeks in the data model, so the following Design Blog post may help there.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/DateA...

Sorry if I am way off-base.

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.