Discussion Board for collaboration on QlikView Scripting.
I am trying to create a Milestone/Gantt Chart visualization and I was wondering if anyone knows if the following can be performed using a single chart?
currently I am producing this by overlaying two charts, one for the bar one for the symbols - works well except when you try to scroll, only the top image scrolls disassociating the data.
when I try to put the same info into a line bar chart I get the following:
any ideas would be greatly appreciated
will you provide the sample data
it may possible with bar offset option in expressions
Can you not do this with combo chart with symbols for expressions > 2 and select the horizontal style?
Maybe you could use a combi-chart with bars and points (instead of lines). Maybe also this posting is helpful: Recipe for a Gantt chart
when wanting to use multiple symbols in a chart, especially when trying to build a milestone chart, a combo chart is the way to go - it will allow differnt symbols for different expressions
Here is some sample data:
The SwimLane is the different rows
The Duration Bar is the length of the bar
The BarOffset is where the bar Begins
The Milestone are the different symbols
The MilestoneDate is the placement of the symbols
This is what I am trying to do with the second image I pasted.
The thing is the Milestones are variable ~100 different ones, would I need to create an expression for each name?
Currently I have the swimlane name and milestones both as dimensions and milestone date as the expression.
Thanks for the link - I looked at it, but I am currently able to have the Gantt part work, it does not go into how to build in milestones as well.
you are going in right direction using bar chart,please classify each milestone/swimline as an expression each
So I would need to make an expression for each potential (~100 different milestones) - wouldnt't that kill performance?