Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Kirstendelahaye
Contributor
Contributor

Scatter/Bubble chart data points are off chart area

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

Scatter graph.png

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor
Contributor
Author

Thanks!  I will do that.