QlikSense Desktop - Gantt Chart

[aalcaide]

Hello: 

I am looking for a free use Gantt Chart for QlikSense Desktop. I had tried  TIQ Timeline and it worked fine, but it seems the trial period is over, so now the visual is not displayed. 

The point is that I would need another visual in order to graph a Gantt Chart in my report. 

Could you help me with visuals that can perform this? 

Thank you so much in advance.

King regards.

Alicia.

[JordyWegman]

Hi Alicia,

You can build one your own with a bar chart:

1. Use a stacked bar chart, min(StartDate) as first measure, sum(Duration) as the second
2. Switch off gridlines, use master item measure to color the offset white and the duration blue.
3. Set range of x-axis to min(StartDate) and max(EndDate). Set number format of measures to date.
4. Add value labels. Set number format to date for first measure, auto for second.

This is based on a version for QlikView by Matthew Fryer

Jordy

Climber

[jhcoburn]

Thanks for providing this recommendation.

The directions for the Gantt Chart are great got me thru creating the visual with one exception.

Can you please provide a bit more instructions on how to

 use master item measure to color the offset white and the duration blue.  

Thanks

[JordyWegman]

Hi,

If you have created these measures, transfer them to master items and color your master items accordingly. You can then replace the old measures by the master items and it should work.

Another option is to check out the new release of the Vizlib Gantt Chart that does this for you and comes with extra possibilities.

Jordy

Climber

[Giuseppe_Panella]

HI, 

here you have also a video that shows you how to create a Gantt chart using a Qlik Sense Bar chart

[video]

Before to following the steps showed in the video, you have to create two master measures. One for the duration and one for the start date. The start date' master measure color needs to be set to WHITE and the duration needs to be set to a color that you prefer.