topic Re: Need Ideas for Visualization in QlikView

Need Ideas for Visualization

yashcena — Mon, 13 Aug 2018 13:28:39 GMT

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

Re: Need Ideas for Visualization

MWiciok — Mon, 13 Aug 2018 13:42:19 GMT

You could use a Grid-Chart

Matthias

Re: Need Ideas for Visualization

marcus_sommer — Mon, 13 Aug 2018 13:45:46 GMT

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

Re: Need Ideas for Visualization

yashcena — Mon, 13 Aug 2018 13:51:15 GMT

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.

Re: Need Ideas for Visualization

marcus_sommer — Mon, 13 Aug 2018 14:04:50 GMT

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