Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
i attached a Gantt-Chart. I tried to manipulate the gantt-chart by adding a button for example Year or Month or Week or Day.
If i click at the Year-button the Gantt-Chart should show the values for the Year 2008 at the example. Or if i click at the month button the gantt-chart should show the values for the acual month. is something like this possible?
Regards,
Aylin
Hi Aylin,
Yes this is possible.
You may split your date in year and month to use it in your triggers and to calculate variables curyear and curmonth to set in the trigger as "select in field : StartYear", "Value : =curyear"
Best regards
Christian
Hi Christian,
thank you for your help, i splitted my date column into month, year, week, day.but it should show any year not the current year, month, ...If i click on Year, the Gantt Chart should show on the x-axis only 2009, 2010, 2011 and the values. it is a little bit complicate to explain
Hi Aylinbisiren,
I suggest you to create a group of year-month-week-day and add it to the chart. then you can do drill down to the date level you want.
Hope it works.
Hi Aylinbis
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
Christian,
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?
Hi Cassandra,
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
Ex :
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
best regards
Chris