Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Scale dates correctly on gantt chart

I need to make the scale for the dates the week start. I dont want there to be a big gap like it is from 05/01/2013 to 07/01/2013 and so on.

2 Replies
Anonymous
Not applicable
Author

Hi Mindy,

Under the chart properties, in the axes tab, you can set the scale's static step to 7 and the static min to "Min([Start Date])".  However, this method will only work if there are no outliers.  Once more dates keep getting added to the chart, QlikView will dynamically adjust the scale so that it can show the labels without any clutter.

An alternative solution to show the week start metric for the bar chart is to enable either the "Text on Axis" or "Text as Pop-up" display option in the Expressions tab (in chart properties).  Hope that helps!

Not applicable
Author

Sean - Thanks so much for the reply. Solution 1 does not work for me, and solution 2 doesn't help either. I hope that having the week start list box will be enough for the end user.