Update as At 7/5/2014
For those who do not wish to use an extension object, there is a great example of creating a detailed Gantt using a pivot table at the following link. http://community.qlik.com/thread/109784
Attached is a Gantt Chart Extension Object developed specifically for QlikView. In version 2.0 I have tweaked the design a little to make it easier to configure - dates are now configured as expressions, so you can apply the necessary formatting in the object rather than your load script. It also better handles longer time frames via the compress option, as it compresses months into a single cell in the table. (Set the defaults to always be month and compressed if you have very long time frames, otherwise it creates a cell for each day and the HTML table may get excessively large).
You can now compress the time periods displayed by making selections as highlighted below and clicking on the Redraw Chart button.
- Expand and contract nodes in the task tree hierarchy by clicking on the + or – sign.
- Switch between Weekly time series and Monthly time series (default option is configurable)
- Optionally summarize the time periods to display more data in the available screen space
- Assign external URL links that will open when clicking on the <link> text in the task description field.
- Task details display in pop-up 'bubble' when hovering over gantt bar.
- Parent level bars can be set to display always or only when the relevant 'branch' is collapsed
- Optionally assign a specific color to individual task bars.
Note that the chart is currently limited to displaying a single project at a time. Sample data and a sample QlikView application are provided in the attached zip file. The extension object is also packed in the zip as a QAR file. There is also a comprehensive set of instructions and notes in the file READ ME FIRST. Please read these instructions before posting any questions.
I will be adding more functionality and refining it over time. I welcome your feedback and suggestions as to what you would like to see in such an extension object. Please post your comments here and I will follow them up as soon as practical.