Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Gantt Chart - Not showing all values

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?

gantt.PNG.png

5 Replies
rubenmarin

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

Not applicable
Author

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.

gantt2.PNG.png

rubenmarin

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

Not applicable
Author

Thanks for your help guys!

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

gantt3.PNG.png

rubenmarin

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