topic Re: Help Required on "Tracking Project Status" in QlikView

Help Required on "Tracking Project Status"

kevinstanfield — Fri, 05 Jun 2015 11:11:09 GMT

Hi,

This seems very simple to explain but fairly difficult to execute (I'm a very basic QV user- self taught).

What I'm hoping to do is illustrate the changing RAG status of a project over time - so last week project A was "green" the previous week it was "amber" etc.

I've attached a mocked up visual of what I was hoping to achieve - i.e. each project, each week the status is represented by a colour

Project A
Project B
Project C
Project D
Project E
Project F
03/01/2015	10/01/2015	17/01/2015	24/01/2015	31/01/2015	07/02/2015	14/02/2015	21/02/2015	28/02/2015	07/03/2015

Here's hoping you can help.

Thanks in advance.

Kevin

Re: Help Required on "Tracking Project Status"

alexandros17 — Fri, 05 Jun 2015 11:15:00 GMT

Take a look at this:

How to build Gant's diagram and calculate free time?

in the community look for "Gant Diagram"

Re: Help Required on "Tracking Project Status"

Kushal_Chawda — Fri, 05 Jun 2015 11:33:11 GMT

May be this link can help you

https://community.qlik.com/docs/DOC-3113