Files for creation of a Gantt chart

[hic]

Have you ever wanted to create a Gantt chart in QlikView, only to find out that this chart type is not one of the pre-defined charts? Then you should be happy to learn that it is possible to create a Gantt chart and that it is not very difficult. See more on Recipe for Gantt chart.

HIC

[sthservo_bi]

Hi guys,

i have a scenario where the durations from the data can be over night.

The problem is that, sometimes the chart appends the next "row"  directly to the previous one.

The duration measure looks like this:

RangeMax(above(Max (BDERUECK.c_BisZeitstempel),0,RowNo()))
-
RangeMax(Min(BDERUECK.c_VonZeitstempel),RangeMax(Above(Max(BDERUECK.c_BisZeitstempel),1,RowNo()-1)))

Format: BDERUECK.c_VonZeitstempel = dd.mm.yy hh:mm

Bar offset:
if(IsNull(above(Only(MB_Aktivitaet.c_RessourceBezeichnung))), Min(BDERUECK.c_VONZEIT),
RangeMax(0,Min(BDERUECK.c_VONZEIT)-RangeMax(above(Max(BDERUECK.c_BISZEIT),1,rowno()-1))))

Format: BDERUECK.c_VONZEIT = hh:mm (timestamp does not work at all)

Does someone has a fix for that?

Thanks in advance

[sthservo_bi]

Hi guys,

i have a scenario where the durations from the data can be over night.

The problem is that, sometimes the chart appends the next "row"  directly to the previous one.

The duration measure looks like this:

RangeMax(above(Max (BDERUECK.c_BisZeitstempel),0,RowNo()))
-
RangeMax(Min(BDERUECK.c_VonZeitstempel),RangeMax(Above(Max(BDERUECK.c_BisZeitstempel),1,RowNo()-1)))

Format: BDERUECK.c_VonZeitstempel = dd.mm.yy hh:mm

Bar offset:
if(IsNull(above(Only(MB_Aktivitaet.c_RessourceBezeichnung))), Min(BDERUECK.c_VONZEIT),
RangeMax(0,Min(BDERUECK.c_VONZEIT)-RangeMax(above(Max(BDERUECK.c_BISZEIT),1,rowno()-1))))

Format: BDERUECK.c_VONZEIT = hh:mm (timestamp does not work at all)

Does someone has a fix for that?

Thanks in advance

[santosh4195]

Hi @hic 

Is it possible to create Gantt chart for particular day using start time and end time of a project(in my case workspace reservation)? I need a Gantt chart showing the particular room is reserved/available in that time interval. Please help me with any solution!!

Thank you