thanks for clarifying! I thought so.
I have found a workaround by simply conditionalizing the display of the expressions so that the expressions in this one area (it is only one) are not displayed => the axes now all go up only to 30, that's fine.
For that one area I just generated another chart which I also put in the container_box, with another axis.
You could divide the value with the maximum value per dimension (first dimension).
See attached file.
The charts with the blue bars are plotted against a fixed axis. This is regular QlikView behavior.
In the charts with the dark grey bars each value is divided with the maximum value within that dimension. Hence they show a proportion and not the actual value. The highest value is alwasy at 1.
A work around for this is used in the bottom right chart, which has two expressions - one for the proportion and one for actual values on data points. Of course, you will need to hide the axis, since it only goes to 1.
trellis axis.qvw 204.5 K
Hi Alex. I'm pretty new (~3 months' experience) to Qlikview, and I tried your method. The scale of the Y-axis did not change based on the largest value.
I have a trellis chart (line chart) with three cyclic groups as dimensions. Could you please suggest how I can edit your expression to suit my purpose?
Thanks in advance!