Negative and Positive Values in Pie chart - But Total Is Positive

[pnn44794]

Hello:

I'm trying to create a Pie Chart where the totals are positive, but the actual data contains  both positive and negative values and then I want to show the sum in %.  It seems Qlikview is failing on having both negative and positive values available rather than the overall total.  Is there a work around for this behavior?  I get it that you can't have a "negative pie slice", but if the sum total is a positive number, I wouldn't think this is a problem.

[avinashelite]

Yes , if the sum is an positive value then it won't have any issues ....In your case I think their is an negative value that's the reason its not able to build the chart , check the computed values once 

[jyothish8807]

Hi Pnn,

Can you please create a straight chart with same dimension and the below expression you want to use in pie chart ?

If you find any dimension with a '-'ve value, then that should be the root cause.

Else please share some sample. 

[jyothish8807]

Hi Pnn,

Can you please create a straight chart with same dimension and the below expression you want to use in pie chart ?

If you find any dimension with a '-'ve value, then that should be the root cause.

Else please share some sample.