Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
jegadeesan
Creator
Creator

Plotting start date and end date on Gantt Chart

Hi,

Can any one help me in bringing or plotting start date and end date of the project on Gantt chart bars.

Project  ID  -  Plan Star date  - Plan End Date - Design Start Date - Design End Date

    A                  01/25/2015           02/29/2016        02/30/2016               03/16/2017

    B                  01/272015           04/05/2015        04/07/2015               06/25/2015

Requirement 1: I have to show duration of those projects.

Requirement 2: I have to Plot start date and end date of the projects on Gantt chart bars.

Note:  1. I have 4 date fields in my source table.

           2. Legend values are not in single field instead its been two different field like Plan and Design with start date and end date.

Exact Requirement Picture:

3 Replies
swuehl
MVP
MVP

Have a look at

Recipe for a Gantt chart

There are also some more (few) examples for Gantt charts here in the forum.

jegadeesan
Creator
Creator
Author

Thanks swuehi... Its working when we having two date fields where as don't for multiple date fields as our case.

swuehl
MVP
MVP

I think Henric's blog post shows multiple phases per project, so I think it should apply also to your data (planning phase / design phase etc.)

You may need to transform your data, but this is something you should probably do anyway.