Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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.

4 Replies
Highlighted
Partner
Partner

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
Highlighted
Contributor
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

Highlighted
Partner
Partner

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
Highlighted
Employee
Employee

HI, 

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

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.