Qlik Sense Calculation of Moving Annual Total (MAT)

[Anonymous]

Please assist with the attached Qlik Sense application,  I am trying to calculate the MAT.

Regards

[itec_pao]

Hi Christopher,

I have come across a solution, in order to provide a good moving annual total (MAT) analysis. The solution is called As-Of table. A very good example is provided here by Henric Conström:

The As-Of Table

Additionally, by using DateDiff (difference between the two dates), you might create different flags for flagging current 3months, 6months, 1Year, Ytd, etc.

Regards,

Oktay