topic Re: Gantt Chart with Timestamps in QlikView

Gantt Chart with Timestamps

sthservo_bi — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Gantt Chart with Timestamps

sthservo_bi — Tue, 27 Aug 2019 14:45:26 GMT

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))))

Re: Gantt Chart with Timestamps

Brett_Bleess — Thu, 05 Sep 2019 13:54:52 GMT

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