topic Gantt Chart in QlikView

Gantt Chart

Mon, 01 Jun 2015 04:53:25 GMT

Hi there,

I have been asked to update the Gantt chart (I never worked with Gantt chart before) with new spreadsheet. There were some changes to the titles and an extra column. However, when I reloaded chart does not look the same. Instead of timeline showing each month(before pic), it shows each 10 years (after pic). I did not change properties, except for replacing appropriate titles. Could anyone tell me please how to reset to show each month again?

Thank you!

Before

After

Re: Gantt Chart

Anonymous — Mon, 01 Jun 2015 05:37:33 GMT

Hi Nina,

I haven't work on Gantt charts earlier. I found an article about Gantt Charts. Hope it will helpful to make changes for your requirement. Please look at the below link:

Recipe for a Gantt chart

Re: Gantt Chart

Mon, 01 Jun 2015 05:43:58 GMT

Hi Nina,

What changes exactly you have made?

Is that possible to provide sample app before change and after change for easy debugging?

Re: Gantt Chart

petter — Mon, 01 Jun 2015 05:53:11 GMT

It seems that your dates gets messed up so end up with not with a single year but more than a century. So I would look at how the days are interpreted in the load script. Maybe an Excel date is formatted wrongly so it is reset to the first date that Excel can recognize which is I think back in that last day of the 19th century

Re: Gantt Chart

Mon, 01 Jun 2015 21:07:36 GMT

I was able to fix the issue. As I mentioned before some field name changed and I updated everywhere except here. Once I did that, the chart is working properly.

Thank you everyone!