Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Positive and negative values in Pie Chart

Hi there,

I got a dynamic Pie Chart, which is created depending on the chosen values.

Sometimes the result is, that there are postive and negative values in this chart. Since, I try to figure out a certain potential of the variable, this case is happening a lot. It means that the variable reached its full potential which I would like to show in this pie chart in some way.

Is there any chance to do this nicely?

Thanks a lot in advance.

Alexander

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I suggest using a stacked bar chart instead of a pie chart.

View solution in original post

6 Replies
MK_QSL
MVP
MVP

PIE Chart can't show Negative Values...

There are some tricks to show -Ve values but it will misguide to the analyst.

check below thread.

How to create a pie chart with positive and negative values

manojkulkarni
Partner - Specialist II
Partner - Specialist II

You cann't represent negative values in pie chart. Instead you use color coding for text or pie for negative values.

Not applicable
Author

Logically it doesn't make sense to have a fabs slice on a pie chart unless all your values were negative, all you are doing is under proportioning the counterweight.

Anonymous
Not applicable
Author

I suggest using a stacked bar chart instead of a pie chart.

flipside
Partner - Specialist II
Partner - Specialist II

As others have stated, a pie chart isn't really the best option because it cannot show negatives and positives together on one pie.

You could, however, create two expressions and group them so the user can switch between positive results and negative results using the cyclic button.

EXPR1 - Positives: RangeMax(Value,0)

EXPR2 - Negatives: RangeMin(Value,0)

This works best when there is a legend with numbers showing and the Suppress Zero Values option unchecked.

flipside

Not applicable
Author

Thanks to all of you, but I think this works the best.