Thank you inadvance for the help with the following, I have tried to find answers to my questions here and on the web but have not succeeded with everything.
I want to create charts/tables in QlikView (version 11) with the following and I need the formulas for those:
1- "Three-year average for the previous 12 months rolling": ie the average of the past three rolling 12 months.
Tex 201201 should be = (0(200901) +355(201001) +264(201101)) / 3, see the attached Excel file.
2- "The average of the last three years": ie the average number of persons per month for the last three years. e.g. 201202 should be = (15(200902) +8(201002) +25 (201102)) / 3, see the attached Excel file.
The data you have provided seems to be an extract from QlikView's chart which seems to be already pre-aggregated. To help you best, I would request you to provide the non-aggregated data so that we can see what all you have. It would be best if you are able to share your qvw. If confidentiality is a concern, you can check this out
It works very well and I want to thank you very much for this.
An completed question: How can I get the calculations in those 5 expressions in the script instead of getting them already calculated during the upload of the data? What will be the changes that I have to do in the equations to make them work in the scripts?