Hoping you can help me as well... I have a Gantt chart with a task start month and/or year selection fields related to it. I want the data to show the projects that have a date that falls within the selected criteria, not necessarily the start date. For example, I want to show all projects with tasks active in September 2014. Right now, my Start Date is related to the start of the task. If a task started in August but is still active in September, I want it to be displayed. Thoughts?
I've done something like this once.
Let's say %D is calendar_date (you will build a calendar table with all dates from starting point to today
Let's say %D1 is start_date of your project.
Then know you pick up a date in your calendar but there is NO relation with %D1 yet.
So you must script it to create a relation between %D1 and %D
Project starts on 1st of sept and ends on 20 of october.
Make a link for THIS project_id between %D1 and %D on this period. So when you pick up any date between 1st sep and 20th oct you'll have an answer : project_id
I hope this is clear enough. Unfortunately I can't share it right now
Did you ever resolve this issue? I have been working on a Gantt Chart extension object and i think the latest version I posted on community does what you are after. The image below shows how some options and a refresh button allow selection of the relevant level.
You can download the latest version here http://community.qlik.com/docs/DOC-3427