Set reference line in scatter chart according to scale
since it's easier to explain with an example, the attached file is what I would like to obtain.
So I would like to be able to set the position of a reference line according to the scale of the axis.
I see you coming, telling me it's easy! Well, if I want to set it from the maximum value in my chart (as you can set the max scale), yes. But I would like to position it at the middle of the axis itself, without consideration on the value of the points.
So if as in the example, my axis goes from 0 to 400, I want to set it at 400 / 2. But automatically, since the max can change.
Hope the explaination is good enough, many thanks in advance for your help!
There is no way to reference the Max from within a chart in qlikview (as far as I know). So the solution here would be to set the max manually, and then use the same function to set your reference line.
To set a "manual Max" you will need to max using the aggregate function over the dimension, containing the same expression for that axis. For example if your Y expression is "=sum(Amount)" and your dimension is "Month" then your function would look like:
I also X by 1.1 or some arbitrary amount so that the greatest figures are not exactly on the edge of the chart. I also use the ceil function to round the max to the nearest figure:
Each reference line would use this formula, divided by 2.
In addition to using a reference line, you could aslo use gridlines and set the step to [the maximum for that axis]/2. This would add flexibility if you wanted to specify a different number of lines in the future.