Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've pulled together some data to use in a scatter chart showing a list of customers with number of products on the X axis and gross margin on the y axis. However, I've noticed that if I choose the data in such a way that one of the customers has a negative margin then the scatter chart refuses to show any data.
Is this a restriction with scatter charts in general so that they won't show negative values? Is there any way of overriding this in Qlikview?
Thanks!
Ben
use FABS( Your Expression) function to avoid -ve values.
Vikas
That doesn't really help as it would skew the data. For example, I wouldn't want a customer making a loss of 10m to look like they're making a profit of 10m in the scatter chart.