Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Negative values on scatter chart?

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

2 Replies
vikasmahajan

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

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.