topic Re: Gant Chart Help in QlikView

Gant Chart Help

Tue, 19 Aug 2014 10:11:33 GMT

Dear Qlik Users,

I am trying to produce a Gant chart that shows activity over a day. The table of data is similar to the below:

Task	Job	Start Time	Duration
A	1	09:00	00:15
A	9	17:00	00:15
C	4	12:00	00:20
C	8	16:00	00:20
A	2	10:00	00:20
B	3	11.00	00:15
B	7	13:00	00:15
A	7	15:00	00:15
B	6	14:00	00:20

My desired outcome would look similar to the below - where "non captured" time is simply a gap between tasks

Can anyone give me some guidance on how to do it? Please note that my data is not ordered.

I've tried previously to create a bar chart with the Jobs plotting across the bottom and using a bar offset to plot the duration amounts in the correct place but I don't think it is possible to overlap the separate jobs so it is only in one column?

Any advice/help would be greatly appreciated.

Many thanks.

Drew

Re: Gant Chart Help

sujeetsingh — Tue, 19 Aug 2014 10:12:50 GMT

It seems you need to adjust the scale

Re: Gant Chart Help

sujeetsingh — Tue, 19 Aug 2014 10:13:45 GMT

Try stacked chart

Re: Gant Chart Help

ecolomer — Tue, 19 Aug 2014 10:15:42 GMT

Here you are an example of Gannt

Re: Gant Chart Help

Tue, 19 Aug 2014 10:21:50 GMT

Hi Enrique,

This is useful but I would now need to plot all of the "promocion"s on one column - the reason I that my data might have 300 "promocion" options.

Thanks,

Drew

Re: Re: Gant Chart Help

ecolomer — Tue, 19 Aug 2014 10:31:35 GMT

Re: Re: Gant Chart Help

ecolomer — Tue, 19 Aug 2014 10:34:24 GMT

OK, you can modify input data with gaps in colour=blank

Re: Gant Chart Help

Tue, 19 Aug 2014 10:37:04 GMT

Hi Enrique,

This is useful but your jobs are still not showing on one column? The issue is that in my data I may have Jobs up to number 200 so this wouldn't visually work with this amount of data. Thank you for your help though.

Drew

Re: Gant Chart Help

Mon, 01 Sep 2014 12:30:58 GMT

Does anyone else have any thoughts on this? I need to have the information plotted on the same bar (in excel you can use series overlap)

Re: Gant Chart Help

Mon, 01 Sep 2014 14:43:10 GMT

Hi,

You could try this approach:

How to create a Gantt chart using a Pivot table

It's different because it uses colored cells in a pivot table instead of using a bar chart. Still it may be helpful.