Scatter Chart Reference Lines in the middle

[denisb]

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

[zhadrakas · Accepted solution]

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

[denisb]

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