Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))))
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))))
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