Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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.