Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
egsilva21
New Contributor

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 ?

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Dynamically position the reference line on a scatter plot

Try this

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


Regards,

KKR

View solution in original post

3 Replies
vvvvvvizard
Contributor III

Re: Dynamically position the reference line on a scatter plot

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

Highlighted
egsilva21
New Contributor

Re: Dynamically position the reference line on a scatter plot

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

Highlighted
Not applicable

Re: Dynamically position the reference line on a scatter plot

Try this

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


Regards,

KKR

View solution in original post