Negative and Positive Values in Pie chart - But Total Is Positive
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.
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