Dear Qlik Users,
I am trying to produce a Gant chart that shows activity over a day. The table of data is similar to the below:
My desired outcome would look similar to the below - where "non captured" time is simply a gap between tasks
Can anyone give me some guidance on how to do it? Please note that my data is not ordered.
I've tried previously to create a bar chart with the Jobs plotting across the bottom and using a bar offset to plot the duration amounts in the correct place but I don't think it is possible to overlap the separate jobs so it is only in one column?
Any advice/help would be greatly appreciated.
This is useful but your jobs are still not showing on one column? The issue is that in my data I may have Jobs up to number 200 so this wouldn't visually work with this amount of data. Thank you for your help though.
You could try this approach:
It's different because it uses colored cells in a pivot table instead of using a bar chart. Still it may be helpful.