topic Re: How to Display Negative values in Pie Chart? in QlikView

How to Display Negative values in Pie Chart?

Navars — Fri, 11 Sep 2015 06:27:30 GMT

Hi folks,

In my data it has some negative values, I want to show that negative values as well as positive values in my pie chart.

find the data and sample chart, Please help me on that.

Re: How to Display Negative values in Pie Chart?

oknotsen — Fri, 11 Sep 2015 09:45:28 GMT

If you want to display positive and negative numbers, a pie chart is not the correct / preferred visualization.

Consider using a bar chart instead.

Re: How to Display Negative values in Pie Chart?

jonathandienst — Fri, 11 Sep 2015 09:49:47 GMT

How do expect a pie chart to reflect the negative numbers if there also positive numbers? Onno is correct - a pie chart cannot be used for such as visualisation, and any attempt to force (by Fabs() ing the results, fo example) it will distort the result significantly.

Re: How to Display Negative values in Pie Chart?

vikasmahajan — Fri, 11 Sep 2015 09:51:58 GMT

use FABS command

Re: How to Display Negative values in Pie Chart?

oknotsen — Fri, 11 Sep 2015 09:58:55 GMT

Nah, use a better visualization instead .

Re: How to Display Negative values in Pie Chart?

jonathandienst — Fri, 11 Sep 2015 10:02:17 GMT

DO NOT JUST USE THE FABS COMMAND! This just distorts the data and is still not a useful visualisation

Re: How to Display Negative values in Pie Chart?

vikasmahajan — Fri, 11 Sep 2015 10:51:14 GMT

I think instead of bar chart you can use water fall chart !! for better visualization

Vikas

Re: How to Display Negative values in Pie Chart?

Navars — Fri, 11 Sep 2015 14:21:08 GMT

I tried with FABS it converts the values -ve to +ve and it displays, But my requirement is it shows both -ve as well as +ve values.

Re: How to Display Negative values in Pie Chart?

sudeepkm — Fri, 11 Sep 2015 15:06:33 GMT

I do not want to put it as a suggestion because I do not think PIE chart should be used when you have negative values.

But one possibility is to some how indicate which slices are negative. That you can achieve it by using PIE pop out to show those which are negative.

As Vikas mentioned without using fabs in your expression you can not build the PIE chart. Once you use the fabs in your chart expression then you go to Pie Pop out option to put a condition to show the negative ones as pop out slices.

not sure how end users will take it. but my suggestion to use a st. table with color format to indicate the negative ones than positive values.