Skip to main content
Announcements
Qlik Connect 2025! Join us in Orlando join us for 3 days of immersive learning: REGISTER TODAY

Gantt Chart in Qlik Sense: How-To Tutorial [+VIDEO]

cancel
Showing results for 
Search instead for 
Did you mean: 
anychart
Partner - Specialist

Gantt Chart in Qlik Sense: How-To Tutorial [+VIDEO]

Last Update:

Oct 8, 2024 3:11:29 PM

Updated By:

anychart

Created date:

Oct 8, 2024 3:03:16 PM

Looking for the simplest way to create a Gantt chart in Qlik Sense to further streamline data-driven project management in your company or organization? We’ll show you one right now! Follow this quick tutorial and you’ll learn how to easily visualize project tasks and activities as data in a matter of minutes — on smart, interactive Gantt charts using the intuitive Gantt Chart extension for Qlik Sense by AnyChart, Qlik's Technology Partner.

Watch the video tutorial:

Or read the text-and-pictures version below.

Loading Project Data in Qlik Sense

In Qlik, everything starts with the data.

We are going to create a Gantt chart based on data from an XLSX file that looks as shown below.

project-management-tables-with-data-for-gantt-chart-in-qlik-sense

The tables in the file represent the structure of a company and its project schedule. There are three departments, each of them carrying out several projects. Each task within a project is assigned to a certain employee.

First of all, we will create an app, add this data to Qlik, apply the suggested associations, and load the data.

load-data-to-gantt-chart-in-qlik-sense

Then we need to make sure that Qlik established proper associations between tables.

Let’s create a sheet and add three filter panes by dropping three fields on the sheet: ‘department_name’, ‘project_name’, and ‘task_name’.

drop-3-fields-on-the-sheet

If we switch from ‘Edit’ to ‘View’ and try to select a department and a project, we will see that associated tasks are displayed correctly.

make-sure-associated-tasks-are-shown-correctly

Adding Gantt Chart in Qlik Sense

Now that the data is loaded and the associations between the tables are set up the right way, we can add a Gantt chart.

Go to ‘Custom objects’, find AnyGantt, and drop a Project Chart on the sheet, below the filter panes we added before.

add-a-gantt-chart-using-anygantt-in-qlik-sense

Add dimensions

To configure the Gantt chart, we need to add dimensions representing the hierarchical structure of our data.

We will use the following dimensions: ‘department_name’, ‘project_name’, and ‘task_name.

add-dimensions-to-gantt-chart-in-qlik-sense

Add measures

The next step is adding measures.

Let’s use the ‘start_date’ and ‘finish_date’ fields.

add-measures-to-gantt-chart-in-qlik-sense-1

These measures do not require aggregation, so we can use either the ‘Only()’ aggregation or just the name of the field.

Map data

Then we need to make sure that AnyGantt interprets our dates correctly.

Use the ‘Map as’ drop-down menu to map the ‘start_date’ field as ‘Actual Start’ and ‘finish_date’ as ‘Actual Finish’.

As you can see, you can also map a date as ‘Baseline Start’, ‘Baseline Finish’, ‘Actual Progress’, “Baseline Progress”, or “Data Field”.

map-project-data-in-gantt-chart-in-qlik-sense

Preliminary result

After these steps, we can already see a Gantt chart:

preliminary-gantt-chart-in-qlik-sense

The data grid on the left displays the hierarchy of departments, projects, and tasks.

The timeline on the right displays the duration of tasks.

Show actual progress

Let’s add one more measure, ‘progress’, and map it as ‘Actual Progress’.

Please note that you do not need to aggregate it.

show-actual-progress-on-gantt-chart-in-qlik-sense

Now you can see progress bars.

Result: Gantt Chart in Qlik Sense, Built with Real Ease

That is it, the Gantt chart is ready:

final-result-of-interractive-gantt-chart-in-qlik-sense-created-with-anygantt-extension-by-anychart

In the ‘View’ mode, select a department or a project in a filter pane, and the Gantt chart will display the related tasks.

It is very easy!

gantt-chart-in-qlik-sense

Helpful Links

Questions?

If you have any questions on how to create a Gantt chart or any other chart type using AnyChart's Extensions for Qlik Sense, drop us a note in the comments below or contact AnyChart's Support Team directly.