Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.)
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
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
Thanks! I will do that.