Need Ideas for Visualization

[yashcena]

I have a column named Project Stage with values like New, Initiation, Deployment etc.

I want to show the status of each project like this:

The stage in which the project is currently in, that stage should be shown like in the above image.

Can someone help me with this? Is is doable in qlikview?

Thanks,

Yash

[MWiciok]

You could use a Grid-Chart

Matthias

[marcus_sommer]

I think you won't get a layout like in your example but there will be ways to displays this kind of information maybe within a pivot-table or a (stacked?) bar-chart. Maybe the following could give you some ideas:

Recipe for a Gantt chart‌

Files for creation of a Gantt chart

How to create a Gantt chart using a Pivot table

Gantt Chart Extension Object (version 2.0)

- Marcus

[yashcena]

Thank you for sharing the links Marcus. I went through those but I dont have the dates when the Project Stage changes in my data model.

[marcus_sommer]

I think this doesn't matter because in each way you will need to use some generic data like 1,2,3, ... instead of the dates and/or =1 as chart-expression or something similar - because a chart need numbers to display data.

Before I would try the suggestion from Matthias which looks quite nice and is probably easier to implement.

- Marcus