Help Required on "Tracking Project Status"

[kevinstanfield]

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

[alexandros17]

Take a look at this:

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

in the community look for "Gant Diagram"

[Kushal_Chawda]

May be this link can help you

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