topic Re: Scale dates correctly on gantt chart in QlikView

Scale dates correctly on gantt chart

Tue, 22 Apr 2014 15:16:26 GMT

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.

Re: Scale dates correctly on gantt chart

Anonymous — Thu, 24 Apr 2014 17:25:59 GMT

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!

Re: Scale dates correctly on gantt chart

Thu, 24 Apr 2014 18:20:20 GMT

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.