I have a problem with the addition of values in a table. I guess it can be solved with a macro. Unfortunately I have no experience in with makros. It should calculate the first 12 values in an additional column and the number of rows should be counted. The rows with null values are not be counted.
I can see, that in your xls column 52 woche is calculated from some fields from columns B adn C and also some basel values.
I can see also, that in your QlikView sample those 52 weeks and 12 week values you load inline, so, i can expect, that you plan load them "from outside" or calculate it in your script. Anyway i feel, that you plan, that those fields will be calculated and ready to show just after data reload.
I dont know your business case, but don't you need any selections and calculations "on the fly" in your application?
About your "avg" problem - where is it? In load script or in the chart expression?
And last question.... where are you from? Maybe we can meet and take a look closer on your case ?
i understand, that Value column (in your QlikView table SU column) is data in week granularity. You getting it from external database.
1. I try to understand if 52 week and 12 week KPI's you need:
- get from externel database,
- calculate in load script
- or maybe calculate it on the fly (using chart expression).
I understand, that for each week you have some KPI (12 weeks) related to last (or maybe next) 12 weeks.
2. Is 52 weeks KPI also related to 52 last (or maybe next) weeks?
3. Do you need in your appliocation some another KPI's, like for example 24,40, etc. weeks, or maybe you like to let user set number of weeks to have dynamic X weeks KPI?
I'am not sure if it is difference you are talking about, but i can see in your table that for instance for week 2011/34 you have value 14331 in column "52 weeks" and value 13.829 in column "cal 52 weeks".
I'am in Warsaw, so i have 6 hours by car to Berlin