Creating a gantt chart in QlikView

[stevedark]

Hi there,

I have created an approximation of a Gantt chart in QlikView, but can not get exactly what I am after. I would be interested if anyone has any suggestions. I have attempted using both bar offsets and invisible stacked bars - but there are slight issues with both approaches. The following screenshot explains what those issues are:

I can post further details of what I have done in each of the three cases if required.

Regards,
Steve

[#2]

Read some values like

LOAD * INLINE [
Object, Start, End
A, 1, 4
B, 4, 6
C, 6, 10
];

Then make a bar chart with Object as dimension and sum(End-Start) as expression. Change the Orientation on the Style tab. Open the expression properties (click on the small + next to the expression) and select "Move bar" and enter Start as value.

[stevedark]

Hi there,

Thanks for your response.

The horizontal chart with the Bar Offset applied is exactly what I have done in the third example. The issue I have with that approach is (to use your inline data) that A will show a value of 4 in the popup and when exported to Excel, rather than 5. It is the sum of the offset and the bar that I need to show.

Cheers,
Steve

[#4]

Sorry, didn't read carefully enough first time 🙂

Hm, ok, well. I guess the pop-up will show wrong values since the bars actual width is shown. I don't see the reason for the user to see the value of the width in your case since it is always 15. Turn off the pop-up labels (presentation tab) and then create a second expression with the actual value that you want to show. Make the second expression only show as "Text as pop-up". Now a "correct" value should show when holding the mouse over the bars.

When it comes to excel I guess you will have to write a macro function that exports the table to an excel file. Only export the "correct" values when doing this. The macro can be fired when pressing a button. Simple remove export to excel on the chart or if necessary turn of export to excel completely in document properties.

[#5]

Funny you should post that now I'd given up on getting a Gantt chart with Qlikview during my evaluation; I had to go down to minutes, and it just wasn't simple to set up, big disappointement (I already had to use the trick of invisible offset with Reporting Services, didn't want to have to go through that a second time, thank you very much). Discovered that JasperReports does this natively btw...

[#6]

Hi Steve and all other! I just had the same issue and came to the result that this must be a bug in earlier QV Versions (I have 8.5). I tried it with the new QV 10 and the written values are the sum of offset and value bar. Thats the way I like it! To say it with the little example thate came up hier: [ code ] LOAD * INLINE [ Object, Start, End A, 1, 4 B, 4, 6 C, 6, 10 ]; [ /code ] The values behind A,B and C are 5, 10 and 16 in QV V10. In V8.5 its just 4,6 and 10.

[#7]

I think thats the best you will get as Gnatt Charts are not the best in QV.

Id be interested to see how you solved this though, if at all.

[stevedark]

Hi All,

In QlikView 10 there is a new feature which allows you to embed third party chart types within QlikView. One of the examples I have seen of this functionality is a gantt chart. It looks very nice - but I have not tried implementing one myself yet - I'm not even sure if it ships with QlikView or whether you have to hunt it out. I would be interested to know if anyone has got this functionality working.

Regards,
Steve

[#9]

Dear Swe,

I made the same sample but i could not make it properly. I am using Qlikview 9.0. in fact, i could not do this part:

"expression properties (click on the small + next to the expression) and select "Move bar" and enter Start as value".

can you please help me.

[#10]

Hi MK. You just have to create a stacked bar chart where you hide the 1st formula. attached you will find a little example with the data, swe suggested. as I said before the same qvw file looks different in qv 8.5 and the new qv10. Version 8.5 does not give the right values from my point of view. I put 2 screenshots into the zip too, so you can see what I mean. Steve is right. Version 10 has the possibility to embed self developed charts and I also saw the Gantt example on the QV website. But I didn't found the provider of this Gantt chart with Google. Anybody has a suggestion?