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