Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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 (1)
0 Replies