topic Re: Dynamically position the reference line on a scatter plot in QlikView

Dynamically position the reference line on a scatter plot

Anonymous — Fri, 10 Apr 2015 17:04:05 GMT

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 ?

Re: Dynamically position the reference line on a scatter plot

vvvvvvizard — Fri, 10 Apr 2015 17:21:12 GMT

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

Re: Dynamically position the reference line on a scatter plot

Anonymous — Fri, 10 Apr 2015 18:01:15 GMT

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

Re: Dynamically position the reference line on a scatter plot

Wed, 15 Jul 2015 10:11:14 GMT

Try this

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

Regards,

KKR