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: 
gbernabo
Contributor II
Contributor II

Yet another Moving annual total (MAT) question

Dear Qliksensers, I've been reading this forum looking for this answer many times to no avail. 

I need to create a bar chart with the sum of my data grouped in MATs, that is the last month I have loaded (usualy two months before the actual date) plus the previous 11 months.

I've created the autocalendar but I have no idea how to get from that to MAT, only to YTD.

My data looks like this:

SalesImp_date
201172020-Sep
78292020-Aug
134152020-Jul
149752020-Jun
167162020-May
220042020-Apr
59192020-Mar
160492020-Feb

 

And so on until 2007-Jan

And I expect to get a chart like this:

 
 

temp.png

Where each Year is the sum of 12 months.

Can you give me a clue as how to work this out?

I've attached a mock data file to use as example.

Thank you in advance!

 

 

Labels (3)
0 Replies