topic Re: Still showing negative value on the graph in a Sum in QlikView

Still showing negative value on the graph in a Sum

Wed, 03 Sep 2014 05:37:25 GMT

Hi,

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?

Thanks.

Re: Still showing negative value on the graph in a Sum

tresB — Wed, 03 Sep 2014 05:44:12 GMT

Could you explain a bit more, possibly with your qvw with sample data?

Re: Still showing negative value on the graph in a Sum

jagan — Wed, 03 Sep 2014 05:45:25 GMT

Hi,

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.

Regards,

jagan.

Re: Still showing negative value on the graph in a Sum

Wed, 03 Sep 2014 06:10:08 GMT

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...)

Re: Still showing negative value on the graph in a Sum

Wed, 03 Sep 2014 06:29:14 GMT

Forget my point, it is stupid.... I'll find another way to present the graph. (to show negative dimension and the correct sum).

Thanks.