Scatter/Bubble chart data points are off chart area

[Kirstendelahaye]

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.)

 

[rwunderlich · Accepted solution]

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

[Kirstendelahaye]

Thanks!  I will do that.