topic Re: Plotting start date and end date on Gantt Chart in QlikView

Plotting start date and end date on Gantt Chart

jegadeesan — Wed, 25 Nov 2020 16:16:04 GMT

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:

swuehl — Wed, 06 Apr 2016 21:36:15 GMT

Have a look at

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

jegadeesan — Mon, 11 Apr 2016 18:05:49 GMT

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

swuehl — Mon, 11 Apr 2016 23:09:57 GMT

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.