Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
aalcaide
Partner - Contributor

QlikSense Desktop - Gantt Chart

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.

Labels (2)
4 Replies
JordyWegman
Partner - Master

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
 
2019-06-27 11_57_10-Qlik Sense Desktop.png
 
Jordy
Climber
Work smarter, not harder
jhcoburn
Contributor

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
Partner - Master

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

Work smarter, not harder
Giuseppe_Panella
Employee

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.