topic Gantt Chart in QlikView

Gantt Chart

Fri, 08 May 2009 19:17:31 GMT

Hello all.

I am trying to create a simple Gantt chart using a horizontal stacked bar chart, but I am having some problems with the scale always starting from 1900 when more than one expression is used.

I have attached a QVW and a small Excel spreadsheet of data illustrating the problem. A more detailed explanation is in the QVW file.

If anyone has any ideas or manages to fix it that would be great!

Thanks
Thom.

Gantt Chart

Fri, 08 May 2009 19:18:25 GMT

Data source is attached

Gantt Chart

Fri, 08 May 2009 21:11:25 GMT

Funny, I was just working on Gantt charts yesterday. I had the same issues you're dealing with, so I came up with a nice way to get it done.

I use the start date as the first expression and then set it to Invisible. This allowed me to remove the Bar Offset. I then used the Static Min to define where the chart should begin. It works pretty well, you'll just have to adjust your colors as the first invisible bar still uses up the first color.

Gantt Chart

Fri, 08 May 2009 21:34:53 GMT

That seems to have done the trick. Thanks NMiller!

Gantt Chart

Wed, 23 Jun 2010 17:05:13 GMT

Hi,

were u able to create same chart which u have as a imgae in this qvw..third one.

Please let me know.and if it is done please send me sample application.

Thanks

Danzy

Gantt Chart

Fri, 19 Nov 2010 13:15:52 GMT

Hi,

What you need to do is to change the Number format of the first expression (StartDate) to Date (MMM-YY). All expressions have to be in the same number format.

Kind regards,

Janusz Twardziak

Gantt Chart

Thu, 17 Mar 2011 05:42:34 GMT

Hi All

As most of you here worked on Gantt Chart. Hope you guys can help me out.

I have installed QV10(Personal Edition) in my machine and also have installed the extension which is available in the extension folder of the installation folder.

But unfortunately I am not able to see the Gantt Chart in the Right Click(On the document) --> New object --> Chart --> Chart type.

Have any of you guys created Gantt Chart using Personal Edition? If yes please help me out for the same.

I want to create the Gantt chart using personal edition at the earliest.

Gantt Chart

Thu, 07 Apr 2011 08:28:08 GMT

Switch to Webview mode -> new sheet object-> Extension objects and drag the "gantt" to your worksheet.

Gantt Chart

Thu, 07 Apr 2011 09:55:41 GMT

Hi AldoDohle

Yes I have already got to know that. Forgot to update back here! 🙂

Many thanks for your time and help.

Re: Gantt Chart

Lee_Matthews — Mon, 24 Sep 2012 23:50:32 GMT

I have been working on a dedicated QlikView Gantt Chart extension object that shows the task tree and lets the user expand & contract the tree. I have just posted a preliminary version of this here http://community.qlik.com/docs/DOC-3427

It is working well with the sample data I built. However I would be keen for others to try it and provide feedback through community (as comments attached through the link provided) so I can resolve any bugs and add functionality that people actually want.