Hello,
following problem:
I've created a QlikView-file that should represent costs (actual, forecast, target) and quantities (same here).
There are x productgroups and every group have a different amount of products (example: Productgroup 1 have 10 products, productgroup 2 have 7 prodcuts, ...). In one productgroup couldn't be the same product then in another.
Till now it's no problem and I will build up the table like this for example:
| Productgroup | Product | Actual costs | Target costs | Forcecast costs | Actual quantitie | Target quantitie | Forecast quantitie |
| 1. Productgroup | Product 1.1 | 10 | 20 | 18 | 35 | 40 | 37 |
| 1. Productgroup | Product 1.2 | 15 | 20 | 22 | 10 | 30 | 15 |
| 1. Productgroup | Product 1.3 | 12 | 20 | 15 | 20 | 30 | 35 |
| 2. Productgroup | Product 2.1 | 30 | 40 | 35 | 100 | 200 | 140 |
| 2. Productgroup | Product 2.2 | 20 | 30 | 30 | 5000 | 5000 | 6000 |
| 2. Productgroup | Product 2.3 | 12 | 30 | 30 | 200 | 400 | 400 |
| 2. Productgroup | Product 2.4 | 32 | 40 | 40 | 3000 | 5000 | 5000 |
| 2. Productgroup | Product 2.5 | 7 | 20 | 13 | 10 | 20 | 15 |
But I also need to consider the time-dimension - That means, the given table is valid for the actual year 2012. Now I need to break it down on a monthly view and I need to add the data from the last year 2011 (there the forecast get droped).
How could I add the time-dimension in this table? Should I create a complete new table? Is it possible to build it up in only one table? -> Later at Qlikview I will change the view between the years and the months (to get a more detailed view).
Thanks for every help.
