Moving Annual Total (MAT) by week

nancymarmat — Fri, 27 Mar 2020 15:32:38 GMT

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.

Re: Moving Annual Total (MAT) by week

Brett_Bleess — Tue, 21 Apr 2020 20:47:53 GMT

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/DateAndTimeFunctions/weekname.htm

Sorry if I am way off-base.

Regards,
Brett

topic Moving Annual Total (MAT) by week in QlikView

Moving Annual Total (MAT) by week

Re: Moving Annual Total (MAT) by week