Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Gantt diagrams, bar charts

Hi

I need to create a gantt diagram.

I have managed to get it 95% complete but the very last step is killing me.

Probably a minor thing, but I am to blind to see.

The bars in the picture starts on the correct time, but they do not have any ending.

If you look at the top bar, the blue one. It starts at 10:00:00 and should end at 10:22:00

I have marked with the undesirable area white.

In my expression tab I found the bar offset and set it to:

num(min(total <[CIP Line number],DataNumericValue> StartTime)) <-- gives correct start point

Also I found that if I use the folowwing line I would get the correct end point:

num(max(total <[CIP Line number],DataNumericValue> StopTime)) <-- gives correct end point

I want to combine these so I get the actual period selected.

gantt chart_2.bmp

0 Replies