topic Re: Negative and Positive Values in Pie chart - But Total Is Positive in QlikView

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

pnn44794 — Sat, 16 Nov 2024 21:11:54 GMT

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.

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

avinashelite — Fri, 22 Mar 2019 03:58:31 GMT

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

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

jyothish8807 — Fri, 22 Mar 2019 05:25:31 GMT

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.

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

jyothish8807 — Fri, 22 Mar 2019 05:27:10 GMT

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.