Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a question regarding the dimension presentation features for a bar chart in QV11.
In QV10 it is possible to under the presentation tab set the "Max Visible Number" to 60, to uncheck the "Show X- Axis Scrollbar" and to check the "Reversed" checkbox. This way only the 60 last months are shown (month is the dimension), although also older months are included in the chart (however, since the scrollbar is removed the user can not see them). This is important for me since the expressions used are "Rangsum(above(sum(.....), 0, 12))" expressions, and therefore I need to hide the first 12 months since they effectively are calculated using less that 12 months of data (and therefore jibberish).
In QV11 however the "Max Visible Number" feature is removed from the presentation tab, and instead there is a "Show Only" option under the "Dimension limits" tab. This "Show Only" feature does however not only create a view like the "Max Visible Number" feature, but that the dimension is indeed limited to include only the 60 last months. This means that the first 12 months are always showing jibberish (due to my "Rangesum(above(sum(.....), 0, 12))" expression). In order to replicate what is possible in QV10, it seems like I would have to "Show Only" the 72 "Largest" (last) months, and then under the presentation tab "Enable X- Axis Scrollbar" and set the "When number of items exceed" to 60 and check the "Reverse" checkbox, and then also under the "Layout" tab put the scrollbar width to zero. However this feels like a very stupid way of doing what can easily be done in QV10 (it indeed seems like a highly usefull feature have been removed from QV11)
So, what am I missing, can this be done in QV11 in a more reliable way?
Oh, and now I noticed that the above solution is not usable either. If the user for example wish to first look at only months 200711- 201002 (which in my application can be achieved by selecting February 2010 as month), and then later would like to look at all months from 200711- 201210 (which can be achieved by selecting the last month 201210), then the scrollbar (which i have hidden by setting the scrollbar width to zero) gets stuck in such a way that the user can not see the last couple of months (i.e. NOT farmost to the right)....
So is there a solution?