Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
SebastianRichter
Contributor III
Contributor III

Remove start date displayed on bar chart when using as Gantt

Dear experts,

I am creating a Gantt chart by using a bar chart in Qlik Sense.

For each part of the stacked bar I have created master items which is working just fine.

For a few dimensions however it shows xx.xx.1899 on the beginning of the x-axis (circled red) which I suppose is the start of the white bar I'm using before the start of the actual, colored bar.

I do not really understand why it shows for some dimensions and for others it doesn't.

How can I remove this date xx.xx.1899 on all dimensions in my bar chart / Gantt?

SebastianRichter_0-1725345664764.png

 

Appreciate your help. Many thanks in advance.

 

Regards,

Sebastian

Labels (4)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

Try this 

IF(StartDate > 0, Sum(Duration), 0)

 

View solution in original post

1 Reply
Chanty4u
MVP
MVP

Try this 

IF(StartDate > 0, Sum(Duration), 0)