Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create a Gantt chart in Qlik Sense?

Hello All,

I am trying to create a Gantt chart using bar graphs in Qlik Sense and have gotten stuck at a point. Can any one help me with some clues.


Here is the simple dataset I am using form excel -

Start DateEnd DateWorkstream
1/15/20154/13/2015Group A
1/22/20156/23/2015Group B
4/12/20156/12/2015Group C

When I create a bar graph I use the measures as Workstream and Max([End Date])-Min([Start Date]). The thing next I am trying to solve is how to I set a start date fixed, so that the workstreams which are starting a period after the start date are stacked from the date marker they start? Can this be solved by using a stacked graph?

Thanks for any input.Capture.JPG.jpg

8 Replies
JonnyPoole
Employee
Employee

I haven't heard of this being possible in Qlik Sense to date however keep your eye on Branch.Qlik.Com... the site where many QlikView web developers post and share their projects to extend the out of box visualizations.  You may see a Gantt chart there before too long.  For example , there is already a pivot table chart and plenty of other less standard visualizations out there.

Tyler_Waterfall
Employee
Employee

vedanta_‌ any luck on your gantt chart in Sense?

Anonymous
Not applicable
Author

Hi,

Please have a look at this link there was communication few days back on grant chart in qliksense..

http://branch.qlik.com/#!/project/56728f52d1e497241ae697ef

Anonymous
Not applicable
Author

it may answer to my needed but it does not work.

Despite change the date format, i have this bug 2017-11-14_09-18-54.jpg

Anonymous
Not applicable
Author

jkgnpa

date([fiel_date],'YYYY-MM-DD')

las dos ultimas medidas deben ser las fechas

athirabose
Contributor
Contributor

You can redesign the data in below format and plot in a scatter plot with

Y axis -> work stream,

Points -> 'Flag'

X axis -> Date

Color can be given based on the Flag.

FlagEnd DateWorkstream
End Date4/13/2015Group A
End Date6/23/2015Group B
End Date6/12/2015Group C
Start Date1/15/2015Group A
Start Date1/22/2015Group B
Start Date4/12/2015Group C

 

Cheers!

Athira

AntonBaranchuk
Contributor II
Contributor II

take a look at Gantt chart here https://qlik.anychart.com/

AnyGantt Extension for QlikAnyGantt Extension for Qlik

Udatasambasivarao
Contributor
Contributor

Hi, Team,

I'm Facing This issue can anyone help me with Gantt Chart.