topic Creating calendar in QlikView

Creating calendar

pauldamen — Thu, 29 Dec 2011 09:43:18 GMT

Hi all,

Hopefully what I am asking is clear for everyone:

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.

Regards,

Paul

Creating calendar

pauldamen — Thu, 29 Dec 2011 10:56:23 GMT

Any one an idea?

Re: Creating calendar

Thu, 29 Dec 2011 11:15:01 GMT

search for Intervalmatch. I think John has explained this in a good way somewere,

http://community.qlik.com/search.jspa?resultTypes=&dateRange=all&peopleEnabled=true&q=intervalmatch*&containerType=&container=&containerName=&username=johnw&rankBy=relevance&numResults=15
Not the one I thought of but one, http://community.qlik.com/message/104568#104568

Found my test app. Attaching it as well.

Creating calendar

pauldamen — Thu, 29 Dec 2011 11:40:39 GMT

Thanks for your help, somehow I can't get your document intergrated with mine...

Not sure what to copy where in my script