Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Manipulate Gantt-Chart

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

6 Replies
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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.

Lee_Matthews
Former Employee
Former Employee

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.

Summarised.jpg

You can download the latest version here http://community.qlik.com/docs/DOC-3427

cbaqir
Specialist II
Specialist II

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?

Not applicable
Author

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