Trying to change Bar chart into Gantt chart

[Anonymous]

Fellow developers,

  I have been  struggling to build a gantt chart out of this bar chart.

Please give me some Ideas , I'm attaching a sample applicat ion, along with a source file, if some one could suggest how to go about..

B

[#2 · Accepted solution]

Something like this

[Anonymous]

That's beautiful Nick, Is it possible to it this way..If end user wants to show Months instead of Time ( currently in my application measure is Time which starts from 1 ..200...so that the tasks which have to be completed in jan ..will be displayed under jan .. and for feb ... so on.. .

[Anonymous]

Could u explain ...what this funtion does =Start - min(TOTAL Start).

[#5]

Balraj Prabhu wrote:

Could u explain ...what this funtion does =Start - min(TOTAL Start).

It's a number of days from a Start date of earliest task.

[#6]

Balraj Prabhu wrote:

That's beautiful Nick, Is it possible to it this way..If end user wants to show Months instead of Time ( currently in my application measure is Time which starts from 1 ..200...so that the tasks which have to be completed in jan ..will be displayed under jan .. and for feb ... so on.. .

It's not possible to do with Bar Chart type. You have to use Qlikview Extensions. Check this link http://community.qlik.com/message/106643#106643

And it will look like this http://www.youtube.com/watch?v=amEwsKMSHcM

[ToniKautto]

As an addition there is also a blog post available on how the Gant chart can be configured in QlikView;

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/01/recipe-for-gantt-chart