Discussion Board for collaboration on QlikView Layout & Visualizations.
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:
(attached examples : http://community.qlik.com/docs/DOC-3113 )
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
send your chart to excell
then you'll see that expression values for those project are lover than 0
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.
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