I want to make a resource planning in Qlikview. I have resources (Tester, IT etc.) which I have divided over projects, for example I have a tester which has a project between 13/11/2011 and 12//12/2011. I want to make a bar chart in which you can see how many of one resource you are using if you select a period using a slider. So if I select 1/10/2011 till 31/12/2011 I want to see 5 bars, for every resource 1 and it must show how many of that resource you are using.
I found a calendar script on the internet, which helped me a lot. The only problem I now have is that it only shows me totals. So I can select dates using the slider but it will only show me the total number I have loaded, also if I select a date range it will show a total on every date. I just need the total for the range.
Can anyone help me?
I have attached the document, hopefully it is clear.