Stacked Gant Chart problem

[Jonathan_Alm]

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:

(attached examples : http://community.qlik.com/docs/DOC-3113 )

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/01/recipe-for-gantt-chart

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

[#2]

send your chart to excell

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

[Jonathan_Alm]

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.

[#4]

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

Efternamn	Projekt	Duration
Adamsson	P3	129,00
Adamsson	P2	-90,00
Alm	P1	274,00
Karlsson	P1	102,00
Karlsson	P3	37,00
Larsson	P1	191,00
Matsson	P4	151,00
Niklsson	P3	218,00
Niklsson	P4	0,00
Olsons	P1	218,00
Olsons	P4	0,00
Olsons	P2	-89,00
Svensson	P1	171,00
Svensson	P3	-171,00

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