topic Re: Negative values on scatter chart? in QlikView

Negative values on scatter chart?

Fri, 11 Apr 2014 10:12:05 GMT

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

Re: Negative values on scatter chart?

vikasmahajan — Fri, 11 Apr 2014 10:14:18 GMT

use FABS( Your Expression) function to avoid -ve values.

Vikas

Re: Negative values on scatter chart?

Fri, 11 Apr 2014 10:22:15 GMT

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.