Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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.