Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Still showing negative value on the graph in a Sum

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?

ex1.jpg

Thanks.ex.jpg

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

4 Replies
tresesco
MVP
MVP

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

jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

Not applicable
Author

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

Not applicable
Author

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

Thanks.