Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
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
Highlighted
Contributor II

Re: Positive and negative values in Pie Chart

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

View solution in original post

6 Replies
Highlighted
MVP
MVP

Re: Positive and negative values in Pie Chart

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

Highlighted
Partner
Partner

Re: Positive and negative values in Pie Chart

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

Highlighted
Not applicable

Re: Positive and negative values in Pie Chart

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.

Highlighted
Contributor II

Re: Positive and negative values in Pie Chart

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

View solution in original post

Highlighted
Valued Contributor II

Re: Positive and negative values in Pie Chart

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

Highlighted
Not applicable

Re: Positive and negative values in Pie Chart

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