Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Contributor
Contributor

Thanks!  I will do that.