6 Replies Latest reply: Sep 25, 2014 8:36 AM by christianj RSS

Manipulate Gantt-Chart

aylinbis

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

  • Manipulate Gantt-Chart
    christianj

    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

    • Manipulate Gantt-Chart
      aylinbis

      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

    • Re: Manipulate Gantt-Chart
      cbaqirDHDS

      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?

      • Re: Manipulate Gantt-Chart
        christianj

        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

  • Re: Manipulate Gantt-Chart
    Lee Matthews

    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