topic Re: Gantt type chart in QlikView

Gantt type chart

Tue, 12 Aug 2014 10:52:50 GMT

Hi,

I've created a Gantt-style chart using a stacked bar chart that displays pretty much what I want it to. However, the way I've done it uses a lot of memory due to using 40+ expressions, I'm wondering if anyone has a better idea of going about things.

I have several events with a start time, then each event has sub-events that each have start and end times. I've calculated the minutes in between start and and end times, given each sub-event a rank based on its start time, then stacked the values in rank order.

So for each event, the expressions run something like this:

=only({$<rank={'1'}>}prep_time)

=only({$<rank={'1'}>}session_time)

=only({$<rank={'1'}>}close_time)

=only({$<rank={'1'}>}down_time)

=only({$<rank={'2'}>}prep_time)

=only({$<rank={'2'}>}session_time)

=only({$<rank={'2'}>}close_time)

=only({$<rank={'2'}>}down_time)

=only({$<rank={' ..n '}>}prep_time)

=only({$<rank={' ..n '}>}session_time)

=only({$<rank={' ..n '}>}close_time)

=only({$<rank={' ..n '}>}down_time)

for n sub-events.

Currently I've got 10 sub-events, but this will probably need to increase to more.

This is an image of what the chart looks like for 2 events:

Does anyone have any ideas on a different approach?

Thanks

Tom

Re: Gantt type chart

marcus_sommer — Tue, 12 Aug 2014 11:05:05 GMT

It looks like that you have created a crosstable over your different time-areas. From a performance point of view it could be better to create a (additionally) table like that:

timetable:

Load * Inline [

AnyID, TimeCategorie, Value

1, prep_time, 00:05

1, session_time, 00:05

....

];

- Marcus

Re: Gantt type chart

ecolomer — Tue, 12 Aug 2014 11:07:31 GMT

here you have an example

Re: Gantt type chart

Thu, 11 Sep 2014 09:10:58 GMT

Hi Tom,

Here is what I have used to build Gantt Charts. It's a different approach but it might be of use to you:

How to create a Gantt chart using a Pivot table