Splitting values per period into equal week values
I am loading overheads into Qlikview and I want to split the total amount per period equally across weeks. For example if the total amount of overheads in period 2 is £4,000 I want to show £1,000 per week, regardless of when the amount was actually posted. Periods 3,6,9 & 12 have 5 weeks, all the other periods are 4 weeks. This is the load script I am using, what do I need to add?
Re: Splitting values per period into equal week values
Let me explain some more with some examples. What is loaded is the Amount field, but what I want to see is the average Weekly amount (per period) so that if a selection is made in the app for week 3 it shows 50, not 0