Creating Gantt Chart on Qlik Sense to show Planned v/s Actual project /Task progress

[arpdharia]

I have a list of different projects with their planned start/ finish date and actual start/finish data.

Now, I want to show the progress of each project in the form of gantt chart where there will be two horizontal stacked bars one showing planned duration and one showing actual duration of each project with two different colors.

I used Qlik Sense Timeline Chart using the Google ChartAPI extension but was not successful. It allows only four dimensions 

• Dim 1 (required): Main dimension and row label
• Dim 2 (optional): Bar label
• Dim 3 (required): start date, format YYYY-MM-DD (ISO)
• Dim 4 (required): end date, format YYYY-MM-DD (ISO)

I want a solution to show the current progress of each project in comparison with the planned dates.

Can any one help what is the best way to show such comparison in dash board ? This would help management get an idea about the delay of each task with respect to its planned dates.

Excel file is attached for data

[Vegar · Accepted solution]

I think you can manage with your extension, just edit your data model a bit. Take a look at the picture and script below. (I'm using i gantt extension quite similar to yours: https://developer.qlik.com/garden/5c38a38f1f9bf60010baa65e )

[Data]:
LOAD
	[Project_name],
	'Planned' as Type,
	[Planned Start] as Start,
	[Planned Finished] as Finished
FROM [lib://projectdata]
(ooxml, embedded labels, table is Sheet1);

Concatenate
LOAD
	[Project_name],
	'Actual' as Type,
	[Actual Start] as Start,
	[Actual Finished] as Finished
 FROM [lib://projectdata]
(ooxml, embedded labels, table is Sheet1);

 Cheers

Vegar

[arpdharia]

Hi Vegar,

Thank you for the solution, it worked for me!! The only thing I need to figure out is to show different color for stacked bars. Currently the Qlik Sense Timeline Chart using the Google Chart API extension does not have that inbuilt capability to provide with different colors. I will have to search a function that assigns different color to each bar. 

[Jrampone]

Hi there,

How do I generate a Gantt chart using https://developer.qlik.com/garden/5c38a38f1f9bf60010baa65e ) with the same data that was previously used?

Thanks,

JR

[shima_hish]

Hi Arpdharia,

Do you manage to find the function that assigns different color for each bar? can you please share here?

Thank you!

[arpdharia]

Nope I was not able to. The requirements changed so no longer tried to research on it. If anyone has found that please could respond over here so it could be useful in future.

[agostinierika]

Hi,

I'm using this extension and now I find out that it is not possible to export charts in PPT or PDF, but only in excel format.

Do you know if there is a workaround to manage this issue?

Thanks in advance

[Vegar]

My preferred workaround is to use the windows snipping tool. I prefer the snipping tool over export-to-image all the time because it is a much faster approach.

[shima_hish]

Hi,

I managed to get different coloured bar for the timeline. What you need to do is to use the correct Timeline extension that will give different colour for different fields. 

I got mine from here : https://github.com/plzaart/multicolored_timeline

[AntonBaranchuk]

AnyGantt Extension supports it - please take a look https://qlik.anychart.com/

AnyGantt Extension for Qlik