Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jonathan_Alm
Partner - Creator
Partner - Creator

Stacked Gant Chart problem

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, JonathanGantMissing.png

3 Replies
Not applicable

send your chart to excell

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

Jonathan_Alm
Partner - Creator
Partner - Creator
Author

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.

Not applicable

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

EfternamnProjektDuration
AdamssonP3129,00
AdamssonP2-90,00
AlmP1274,00
KarlssonP1102,00
KarlssonP337,00
LarssonP1191,00
MatssonP4151,00
NiklssonP3218,00
NiklssonP40,00
OlsonsP1218,00
OlsonsP40,00
OlsonsP2-89,00
SvenssonP1171,00
SvenssonP3-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