topic Scatter Chart Reference Lines in the middle in QlikView

Scatter Chart Reference Lines in the middle

denisb — Sat, 16 Nov 2024 00:39:29 GMT

Hello,

I have a scatter chart. In this chart I want to have a reference line, exactly in the middle of my x axis. So I need the max value of the x axis in my scatter chart. After a selection, the chart will have a new max value of the x axis. Then I need again a reference line exactly in the middle.

Is there a function? Ideas? 🙂

Thanks

Denis

Re: Scatter Chart Reference Lines in the middle

zhadrakas — Tue, 19 May 2020 05:54:49 GMT

Median Approach:

= Median([X_Axis_Expression]) = Median([Y_Axis_Expression])

max/2 Approach:

Max(Aggr(NODISTINCT [X_Axis_Expression]),Chart_Dimension))/2 Max(Aggr(NODISTINCT [Y_Axis_Expression]),Chart_Dimension))/2

Diagonal Line

https://community.qlik.com/t5/New-to-QlikView/Reference-Line/m-p/242698

Re: Scatter Chart Reference Lines in the middle

denisb — Tue, 19 May 2020 07:38:04 GMT

Thanks.

I use this now:

X = max(aggr(sum(MY_X_VALUES),[MY_DIMENSION])) / 2

Y = max(aggr(SUM([MY_Y_VALUES]),[MY_DIMENSION])) / 2

Best Regards