Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Gantt chart query

Hi guys

I need help

I'm making this gantt chart via 'recipe of gantt chart', but its pretty messed up. I've these tables;

  • Project Names
  • Project Codes
  • Start Date
  • End Date
  • Milestones

            It involves;
               -Requirement Phase
               -Blueprints

                -Functional Requirement Done
                -Business requirement Blah Blah

  • Milestone dates
  • Project Status

          [whether it has been gone live, or dropped or Deployed]

  •      Calender

So this is what I'm getting now

Capturegantt.PNG.png

Though its a half screenshot. the expression i used was; max(End Date)-Min(Start Date) and i know this should not be not be the expression but the funniest part is i cant come up with a new expression.

All i want is something like that

Capture12.PNG.png

The brown color representing that its first milestone has been completed yellow represents the second one, and the red represents the fourth milestone and if it gets go live then it gets all green. This all would be changing colors as per dates. idk how to achieve that but i want to achieve it.

Regards

1 Reply
chaiperi
Contributor III

Re: Gantt chart query

Hi Rabia I am also looking for similar type Gantt Chart Requirement. Are you using Extension by ack or lms ??If you are using Adam's Extension.Can you share it ? or post in this thread? I was not able to download it.

Thanks in advance

Community Browser