Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

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


Gantt chart Data.PNG

 

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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 )

image.png

[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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

9 Replies
Highlighted
Partner
Partner

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 )

image.png

[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

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Highlighted
Contributor
Contributor

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. 

Highlighted
Contributor
Contributor

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

Highlighted
Partner
Partner

Hi Arpdharia,

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

Thank you!
Highlighted
Contributor
Contributor

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.

Highlighted
Partner
Partner

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

Highlighted
Partner
Partner

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.

 

image.png

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Partner
Partner

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

Highlighted
Contributor II
Contributor II

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

AnyGantt Extension for QlikAnyGantt Extension for Qlik