2 Replies Latest reply: May 12, 2014 11:21 AM by Amer Numan RSS

    Simple Gantt Charts: Projects and Milestones

      Hi!

       

      I am looking to make a simply Gantt chart (in QlikView 11) with 2 levels of detail;

       

      - Project Level (dates): Plan/Actual Start, Plan/Actual Finish

      - Milestone Level (dates): Plan/Actual Start, Plan/Actual Finish

       

      The main things I need to show are:

       

      - Range bars showing start and end of each project

      - Markers showing where milestones end along each project

      - Slippage where Actual Finish is past Plan Finish

       

      Extras/nice to have:

       

      - Conditional colors for projects and milestones based on status (red/yellow/green). I have an expression defining this already, i just don't know how to set conditional colors for charts.

       

      - Ability to show milestones as full bars too, but hidden under projects for users to optionally expand/collapse

       

      I appreciate your feedback or sample files. I found a couple of posts around here but the zip files they include as examples aren't working. Thank you!