Solved: Re: Project-Timeline with Milestones needed - Qlik Community

m_pfister · ‎2016-09-12

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

m_pfister · ‎2016-12-02

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.

View solution in original post

vvira1316 · ‎2016-12-01

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

marcus_sommer · ‎2016-12-02

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

- Marcus

m_pfister · ‎2016-12-02

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.

vvira1316 · ‎2016-12-02

Hi Max,

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

Thanks,

Vijay

m_pfister · ‎2016-12-06

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

vvira1316 · ‎2016-12-06

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

vvira1316 · ‎2016-12-14

Hi Max,

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

thanks a lot