See attached example. The source data is per date, not already aggregated per week. I used the Qlikview Components library to create a calendar and set analysis variables. Those are used in most of the expressions. It's not possible to combine the period averages in the same pivot table as the week counts. So the result is three tables, no two. I hope this helps you.
salestodate58.qvw 204.2 K
Thanks for your quick response
In relation to the period analysis (3,6,12 months); i had entered the suggested formulas with the slight alternation to match my data set. I change it up to be a Count formula, as to add count the number of items (and not the sum of).
count( $(vSetRolling12) syscreated)
count( $(vSetRolling6) syscreated)
count( $(vSetRolling3) syscreated)
count( $(vSetMTD) syscreated)
'syscreated' is a date field that is always populated, and is in the data set.
However, All 4 formulas produce the same figures. Where am i going wrong?