topic Re: Gantt Bar Chart ? in QlikView

Gantt Bar Chart ?

MarcoWedel — Sat, 16 Nov 2024 05:13:13 GMT

Hi,

I recently had to visualize the durations of standard activities against a limit and at the same time deliver insight into the cause of prolonged durations drilled down to the different steps each activity consists of.

As those steps run in parallel, I could not use a simple stacked Bar Chart to represent the duration of an activity.
Instead I thought about something like a Gantt/Bar Chart crossover, i.e. on a broad scale looking like an ordinary Bar Chart of activity durations while revealing the internal step sequence of each activity/bar as something like a vertical Gantt Chart when narrowing the activities down to a smaller number.

One example of what I already did looks like:

Are there any similar visualizations already done in QlikView (or any other environment for that matter)?
I would appreciate any hints oder sample applications.

thanks

regards

Marco

Re: Gantt Bar Chart ?

Gysbert_Wassenaar — Sat, 17 Nov 2018 06:25:24 GMT

Very inventive! I haven't seen anything like this before in Qlikview (or Qlik Sense). Well done. Personally I find a horizontal layout easier to read. So I'd only change the orientation setting.

Re: Gantt Bar Chart ?

MarcoWedel — Mon, 19 Nov 2018 11:15:39 GMT

Hi Gysbert,

thanks for your reply.

I guess you are right about having time on the horizontal axis being more intuitive, so I changed this setting:

thanks

Marco

Re: Gantt Bar Chart ?

marcus_sommer — Mon, 19 Nov 2018 13:15:00 GMT

Hi Marco,

as an alternatively I could imagine a table-chart with a heat map like: The-great-heat-chart but with a much higher resolution maybe with 10 x 100 cells as one bar which meant that the widths and heights are very small maybe 1 - 2 pixel and within it you colors your sub-bars.

I'm not sure that these small cells and the needed logic of coloring them are better/easier as your present approach but it might be worth to try. Here another link which might be useful for this topic: How-to-create-a-Gantt-chart-using-a-Pivot-table

- Marcus