Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Rolling 12 months charting

I need to chart rolling 12 months.  I have tried (see attached application).  The results in the application actually break the rolling 12 months for Aug 2015 into monthly figures which is not want i want.  I want each month-year to show actual rolling 12 months, so the figure shown in the totals of the straight table ($1,516,048.74 should be the rolling 12 months for Aug 2015.  How can this be done?

Thank you

3 Replies
Gysbert_Wassenaar

Have you read these blog posts?

Accumulations

The As-Of Table


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Many thanks Gysbert i will go through this should do the trick

Anonymous
Not applicable
Author

Gysbert, the Accumulations article helped very much and i had to do prior transformation of my data at load time.