topic Re: Stacked Gant Chart problem in QlikView

Stacked Gant Chart problem

Jonathan_Alm — Fri, 21 Dec 2012 11:54:45 GMT

Hi,

I am trying to create a Stacked Gant Chart to visualize persons involved in projects and when the projects end.

I am using the "Two Dimensional stacked event chart" as an example:

The problem I have is that time lines on some projects are not displayed until I select a certain project.

I have attached my qvw file and a picture showing the problems I have. The red boxes with X shows examples of where there should be a bar.

The bar is shown if I select that particular employee.

Does anyone have any input on the matter?

Kind regards, Jonathan

Fri, 21 Dec 2012 12:32:36 GMT

send your chart to excell

then you'll see that expression values for those project are lover than 0

Jonathan_Alm — Fri, 21 Dec 2012 12:38:45 GMT

I am not sure I follow you here.

If I right click on the chart and send it to excel I see the duration in YYYY-MM-DD.

Fri, 21 Dec 2012 12:44:37 GMT

it is becouse of display format but if you change whole column format in excell to number you'l see

BTW duration =0 are wrong values too but you cant see that becouse of coincidence :

Niklsson P3 StartDatum = Niklsson P4 StartDatum

Olson P1 StartDatum = Olson P4 StartDatum