Gantt chart query

Tue, 02 Sep 2014 08:22:48 GMT

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

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

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

Re: Gantt chart query

chaper — Wed, 16 Mar 2016 15:16:39 GMT

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

topic Gantt chart query in QlikView

Gantt chart query

Re: Gantt chart query