How do I aggregate opening orders based on differing time periods?

Tue, 24 Sep 2013 12:01:17 GMT

I am new to Qlikview and although I have been able to quickly get a simple dashboard up running, i have 2 fields where I am struggling to get the calculation required to pull back the correct values for the fields. I have opening orders and closing orders. My time dimensions are broken down as Year/Month/Week. At its lowest level the results are fine, but if I want to view at month or year then I need to see the total opening orders for the dimensions selected not the total of each of the weeks within the selected months.

So if I have 3 Teams across a 4 week month, a table might look like the following for opening orders

Team	Week1	Week2	Week3	Week4
A	10	12	15	19
B	20	18	20	12
C	15	16	14	16

At week level it is simple - sum(OpeningOrders) and I get a total for the each week - (45,46,49,47)

but if i view as month I need to see the total for week1 (45) not the combined total across all the weeks (187)! Similarly for year, I want to see the total at month1 week1.

I have looked for other threads etc similar, but not found anything.

thanks

topic How do I aggregate opening orders based on differing time periods? in QlikView

How do I aggregate opening orders based on differing time periods?