Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik experts,
I'm trying to build a Gantt chart in Qlik. I've used these resources to help me and they worked great:
https://www.youtube.com/watch?v=DUcz3q4wf6k
I have a working bar chart as they have provided. However, in my data I can have 1 event with multiple start date / end dates that I want to visualise in this Gantt chart on the same row. Right now the Gantt chart is created by building a bar chart with length of Duration, and stack it on top of an empty white bar. I'm thinking of stacking multiple bars of alternating white/blue on top of each other to visualise this.
Example data:
Ex:
LOAD * INLINE [
Start, Duration, End, Event
'1-1-2023', 2, '3-1-2023', A
'2-1-2023', 5, '7-1-2023', B
'3-1-2023', 10, '13-1-2023', C
'10-1-2023', 2, '12-1-2023', A
'20-1-2023', 2, '22-1-2023', C
];
I'm looking for a way to visualise for event A and C both (or potentially even more, could be 100 as we have many repeating events) durations in 1 bar. I'm thinking of a way to add a white bar on top of the first End date with a length of 17 for A and length 7 for C. Any tips, ideas, suggestions?
Also: our organisation has a policy where they do not want to work with extensions (I cannot influence this), so the AnyGantt extension by AnyChart is not possible.