Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pie Chart

Hello everyone,

pie chart.... between the values that I represent, there are positive and negative values then the graph does not appear for the presence of negative values.

If I have many clients I bypassed the problem by showing the first 15 customers and the rest as other ... at this point the negative value is absorbed and the graph appears.

The problem is when I have a number of customers poor and I can not handle a customer as part of Other.

Can I exclude from the pie chart, the negative value ... if you possible ... how?

Thanks to all in advance.

Gian Paolo

10 Replies
Anonymous
Not applicable
Author

     Sum(Aggr(If(Sum(FV_Imponibile)>0,Sum(FV_Imponibile)), $(=GetCurrentField( _Cliente)) ))

Although the suggestion from pokassov looks more elegant.

Do take note of the comments by msolomovthat a Bar Chart could be better than a Pie Chart.  There is a great book by Stephen Few called Information Dashboard Design which explains pro's & con's of various visualizations that I would highly recommend.