Hi
I have attached an example of QVW that illustrates the problem that I have.
INTRODUCTION:
In summary, the example contains just 2 tables:
- MasterCalendar
- Jobs file
The 2 are linked by a date that I call OrderDate
The "Jobs" file has a number of fields but the ones of interest are:
- No - this is the job number (this is not unique as there can be a number of entries for the same "job"
- Amount - This is the amount charged for each job
We have data spaning 4 years
REQUIREMENT:
We need to show both monthly totals (as in the example) and 12-month rolling averages against time. Just to clarify, for each month we need to show the average of the 12 previous months as at that time (e.g. for Jan 2011 it should show the average of Feb 2010 through to Jan 2011). This needs to be broken down by location as shown in my example for the totals.
The location dimension appears to be confusing QlikView. Any pointers would be highly appreciated.
Thanx in advance
Alexis
