Discussion Board for collaboration related to QlikView App Development.
I use a Sum Value in a graph, but I've got an issue, in some cases it's still showing negative value rather than taking it part of the sum...
See below example.
Any way to fix that?
If you have negative values by dimension for an expression then you will get negative values, if you want to avoid use
Fabs() to make it to positive.
Convert this chart to Straight Table so that you can now where you are getting negative values.
You can also try Chart Properties-> Axes-> Set Static Min as 0.
Hope this helps you.
View solution in original post
Could you explain a bit more, possibly with your qvw with sample data?
Thanks for your quick answer.
Yes, it happens when one dimension is negative. But I don't want to make it positive. I just want to add it to the sum like all the (other dimensions) and show the sum. (What I want is quite simple, don't understand why it's not the standard way...)
Forget my point, it is stupid.... I'll find another way to present the graph. (to show negative dimension and the correct sum).