Stacked Gant Chart problem - Qlik Community

Jonathan_Alm · ‎2012-12-21

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

Report Inappropriate Content · ‎2012-12-21

send your chart to excell

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

Jonathan_Alm · ‎2012-12-21

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.

Report Inappropriate Content · ‎2012-12-21

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