24h gantt chart

[#1]

Hello,

I'm new in qlikview and i need to make a gantt chart, i have seen a lot of examples but i still haven't find a way that will work in my case.

I have an excel table, like the one below, and i need a 24h gantt chart.

I would really appreciate some help to understand the best way of displaying this information.

Thanks in advance.

ModelType	Start	End
DF	00:00:28	00:04:23
DG	00:06:01	00:06:01
DF	00:07:07	03:47:09
D0F	03:58:24	06:06:51
DF	06:08:13	06:08:13
D0F	06:09:18	07:30:33
DG	07:31:06	07:39:58
D0F	07:41:15	07:41:15
DG	07:42:20	21:03:15
D9F	21:04:17	21:05:25
D4G	21:06:30	21:06:30
D9F	21:07:32	21:09:46
D4G	21:10:52	21:11:25
DF	21:12:29	21:12:29
D4G	21:14:06	21:14:07
DF	21:15:07	21:48:32
DG	21:49:38	21:50:10
D9F	21:51:13	23:52:54

[agomes1971]

Hi,

please see this http://www.qlikblog.at/extension-tutorial/

and inside there is this

Gantt Chart Extension Object (version 2.0)

Hope it helps

André Gomes

[#3]

hope following link will help you

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/01/recipe-for-gantt-chart

[#4]

I tried that solution but that gives me the max duration for every model because the expression is Max(End) - Min(Start), i want to show the gaps between the Models in a stacked graph.

This is something that happens in a sequence like a schedule.

Is there any expression that I could use in the example that you gave me to achieve this?

Do you have any suggestion how to achieve this?

Thank you for your help.

[#5]

find the attached application

[#6]

it's almost perfect, the only problem is that in your solution the graphic gives me the total duration of every model.

This has to be seen as models being produced in one station, I have to identify on the timeline when a model stops and another starts.

Thank you for your help.

[#7]

Can anyone help me with this?

I need to  find a way to display this data in a 24h graphic.

Thank you. 

[#8]

Currently i got this working, any idea how to create a single stacked bar from here?

Thanks.