topic Project-Timeline with Milestones needed in QlikView

Project-Timeline with Milestones needed

m_pfister — Mon, 12 Sep 2016 06:37:04 GMT

Hi!

i'm trying to make an overview over various Projects working. The problem is that as soon as I add milestones to the phases, it is not possible to show all the data in one line.

The goal is to have something like this:

I managed to have stacked and grouped bar charts to have a timeline. However, the grouped version has not got the possibility to show all the events and phases in one line whilst the stacked version does not interpret the milestones correctly:

Both of the versions were used similarly to the diagramms in this Link: Recipe for a Gantt chart

Has anybody got an idea on how to get close to the screenshot above?

Enclosed you find my qvw-file with the attempts.

Regards,

Max

Re: Project-Timeline with Milestones needed

vvira1316 — Thu, 01 Dec 2016 23:33:37 GMT

Hi Max,

Have you tried creating Milestone with 0 duration or a small duration so that it will show on chart but will be very miniscule compared to other bars.

I'm going to try that for my situation and will update here if it works but just thought of providing idea.

Vijay

Re: Project-Timeline with Milestones needed

marcus_sommer — Fri, 02 Dec 2016 09:01:33 GMT

Maybe this is helpful: How to create a Gantt chart using a Pivot table

- Marcus

Re: Project-Timeline with Milestones needed

m_pfister — Fri, 02 Dec 2016 10:00:39 GMT

Thanks for the input!

I managed to get a good result by combining two combi charts (one grouped, one stacked):

The grouped chart for the milestones is an overlay. By adjusting the spaces between the bars the charts have got the same size etc.

Re: Project-Timeline with Milestones needed

vvira1316 — Fri, 02 Dec 2016 16:02:51 GMT

Hi Max,

Will it be possible for you to attach your QVW? It may be helpful to me for a similar requirement.

Thanks,

Vijay

Re: Project-Timeline with Milestones needed

m_pfister — Tue, 06 Dec 2016 17:23:08 GMT

Hi Vijay,

enclosed you find the qvw with the solution as well as some diagramms from trying to get there. I guess that these could be interesting for you as well.

Regards,

Max

Re: Project-Timeline with Milestones needed

vvira1316 — Tue, 06 Dec 2016 17:46:44 GMT

Hi Max,

Thanks for attaching the file. I will look into it. I'm ready to understand it and use it in my situation as I was just able to rearrange my data so perfect timing to get it.

I really appreciate it.

Best Regards,

Vijay

Re: Project-Timeline with Milestones needed

vvira1316 — Wed, 14 Dec 2016 14:37:24 GMT

Hi Max,

your solution did help me. I'm including a screen shot from my work.

thanks a lot