topic Re: Gantt Chart - Not showing all values in QlikView

Gantt Chart - Not showing all values

Wed, 22 Oct 2014 14:46:17 GMT

Howdy, can you take a look at my Gantt chart?

I'm getting close...but i'm not able to display all my values on the chart. I should have values from 10/20-10/22...but something's not right.

Can someone take a peek and let me know what i'm missing?

Re: Gantt Chart - Not showing all values

rubenmarin — Wed, 22 Oct 2014 14:52:44 GMT

Hi David, maybe using "Max(End)" or "Max(End)-0.5" as your static max axis will do the trick

Re: Gantt Chart - Not showing all values

Wed, 22 Oct 2014 15:04:58 GMT

Thank you for your response!

When i do that...i'm still only get 1 date on my chart...I selected 1 workstation, and should see multiple days worth of test date. Table on the right shows my unaltered data.

Re: Gantt Chart - Not showing all values

rubenmarin — Wed, 22 Oct 2014 15:09:16 GMT

If you don't want the selections to change your axis, and assuming your Start and End dates loaded has the 3-day period you want, you can use:

Min: Min({1}Start)

Max: Max({1} End)

It would return the min Start date loaded for the start of the axis and the max End date for the end of the axis.

You can adjust using something like: Max({1} End) -0.5

Re: Gantt Chart - Not showing all values

Wed, 22 Oct 2014 15:16:27 GMT

Thanks for your help guys!

Turned out that having a repeating item code was for some reason problematic...

Re: Gantt Chart - Not showing all values

rubenmarin — Wed, 22 Oct 2014 15:22:18 GMT

If it helps HIC posted time ago a recipe for a Gantt char: http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/01/recipe-for-gantt-chart