topic Re: Scatter/Bubble chart data points are off chart area in QlikView

Scatter/Bubble chart data points are off chart area

Kirstendelahaye — Fri, 15 May 2020 15:27:18 GMT

Hi,

How can I prevent the data points on the graph shown from being plotted partially on and partially off the chart area? (as per the yellow bubble?)

(I don't think I can set a static max for my axis as the data varies a lot, so it wouldn't display well - but I am relatively new to Qlikview - so happy to be wrong.)

Re: Scatter/Bubble chart data points are off chart area

rwunderlich — Fri, 15 May 2020 15:59:14 GMT

You can calculate the static x/y axis values using an expression that gets the current max value and then adds a bit of headroom. Use Aggr() in your static max expression. Assume your chart x expression is "Sum(Sales)" and the Dimension is Company.

max(Aggr(Sum(Sales),Company)) * 1.2

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Scatter/Bubble chart data points are off chart area

Kirstendelahaye — Wed, 03 Jun 2020 08:07:21 GMT

Thanks! I will do that.