Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Dynamically position the reference line on a scatter plot

Dear ,

I'm putting together a dashboard with a scatter plot that will represent a graph quadrants . To mount the quadrant graph have to put two reference lines dividing the graph in half on the x axis y . In the creation of the reference line box has the option to set the percentage of the same position but does not work correctly because I put in 50 % and the line appears near the zero point and not in the middle as expected . Can also be defined by expression but can not calculate what is the value that must be present at the time of presentation for not knowing how to get what maximum values ​​of the axes ( x and y) being presented at the time on the chart.

My question is: how to get these values ​​dynamically ?

1 Solution

Accepted Solutions
Not applicable
Author

Try this

Max(Aggr(Sum(Valor_X),Chart_Dimension))/2


Regards,

KKR

View solution in original post

3 Replies
vvvvvvizard
Partner - Specialist
Partner - Specialist

=Max(the_expression_in the chart)/2 u used in the chart in the reference line

Anonymous
Not applicable
Author

Dear Yusuf

The expression used was Sum ( Valor_X ) . When I use MAX ( Sum ( Valor_X ) ) / 2 gives syntax error. Not to give error have to use MAX ( TOTAL Sum ( Valor_X ) ) / 2. But this does not work because it does not position the bar on site. It does not appear.

Is getting the most value plotted in the graph to the axis of x and y axis ? some function that returns these values.

Emmanoel Gomes da Silva

Not applicable
Author

Try this

Max(Aggr(Sum(Valor_X),Chart_Dimension))/2


Regards,

KKR