Discussion Board for collaboration related to QlikView App Development.
Hello,
I am facing an issue I do not manage to solve.
When I display my scatter chart the auto scale concentrates all the points in the middle of the ordinate axis.
I want the points to be well spread on the ordinate axis.
Does somebody knows how to do it ?
Cedric.
You could play with the Axes' Scales' Static Min/Max.
Go to Chart Properties > Axes > Scale, check the static min and static max and use these formulas:
Y Axis Static Min = min(aggr(avg ([X_Axis]), Dim))
X Axis Static Max = max(aggr(avg ([X_Axis]), Dim))
Y Axis Static Min = min(aggr(avg ([Y_Axis]), Dim))
Y Axis Static Max = max(aggr(avg ([Y_Axis]), Dim))
You can add a percentage to these values to create a "margin" to the sides.
Hope this helps
Fernando
You could play with the Axes' Scales' Static Min/Max.
Go to Chart Properties > Axes > Scale, check the static min and static max and use these formulas:
Y Axis Static Min = min(aggr(avg ([X_Axis]), Dim))
X Axis Static Max = max(aggr(avg ([X_Axis]), Dim))
Y Axis Static Min = min(aggr(avg ([Y_Axis]), Dim))
Y Axis Static Max = max(aggr(avg ([Y_Axis]), Dim))
You can add a percentage to these values to create a "margin" to the sides.
Hope this helps
Fernando
Hello Fernando,
Thank you for your help.
This is a good solution.
Cedric.
we can show the values inside/outside values in bubbles