Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pnn44794
Partner
Partner

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

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.

3 Replies
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
Master II
Master II

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. 

Best Regards,
KC
jyothish8807
Master II
Master II

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. 

Best Regards,
KC