Gant Chart with negative values as start value

[Christiann]

Hi,

I try to realize a Gant Chart after the example app 'Top 10 Viz Tips Part I' from Patric Nordström. (https://community.qlik.com/t5/Documents/Top-10-Viz-tips-Qonnections-2019-Part-I/ta-p/1580174)

I would like to compare the lives of different people and for this the birthday should be the starting value (bar base) and the age the length of the bar.

This works well if the person was born after 1.1.1900.

However, if the person was born before 1.1.1900, the date is (internally) a negative number, but that is not the problem. The scale in the diagram is correct, but the bar is only drawn from 1.1.1900.

Anyone have any idea where my error is or how I can solve the problem?

Many thanks

Christian