Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

Automatic scale for scatter chart

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.

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Automatic scale for scatter chart

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

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: Automatic scale for scatter chart

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

View solution in original post

Highlighted
Not applicable

Re: Automatic scale for scatter chart

Hello Fernando,

Thank you for your help.

This is a good solution.

Cedric.

Highlighted
Not applicable

Re: Automatic scale for scatter chart

we can show the values inside/outside   values in bubbles