Gantt Chart with Timestamps

[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 · Accepted solution]

I found a solution.

I have build the app with instructions of this post

https://community.qlik.com/t5/QlikView-Documents/Files-for-creation-of-a-Gantt-chart/ta-p/1487079

the diffenrence is that my tasks can run for any period of time.

To make the app working you need to take some adjustments to the offset.

The bar offset has to look like this:

if(IsNull(above(Only(ID))), Min(time(hh:mm)),
RangeMax(0,Min('dd.mm.yyyy hh:mm)-RangeMax(above(Max(dd.mm.yyyy hh:mm),1,rowno()-1))))

[Brett_Bleess]

Adding one other link for others that hit this post that may be helpful:

https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Gantt-chart/ba-p/1469842

Regards,
Brett