topic Re: Positive and negative values in Pie Chart in QlikView https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700605#M252881 <HTML><HEAD></HEAD><BODY><P>You cann't represent negative values in pie chart. Instead you use color coding for text or pie for negative values.</P></BODY></HTML> Wed, 18 Jun 2014 09:47:50 GMT manojkulkarni 2014-06-18T09:47:50Z Positive and negative values in Pie Chart https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700603#M252879 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I got a dynamic Pie Chart, which is created depending on the chosen values.</P><P>Sometimes the result is, that there are postive and negative values in this chart. Since, I try to figure out a certain potential of the variable, this case is happening a lot. It means that the variable reached its full potential which I would like to show in this pie chart in some way.</P><P></P><P>Is there any chance to do this nicely?</P><P></P><P>Thanks a lot in advance.</P><P></P><P>Alexander</P></BODY></HTML> Wed, 18 Jun 2014 09:19:35 GMT https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700603#M252879 2014-06-18T09:19:35Z Re: Positive and negative values in Pie Chart https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700604#M252880 <HTML><HEAD></HEAD><BODY><P>PIE Chart can't show Negative Values...</P><P>There are some tricks to show -Ve values but it will misguide to the analyst.</P><P></P><P>check below thread.</P><P></P><P><A href="https://community.qlik.com/thread/51380">How to create a pie chart with positive and negative values</A></P></BODY></HTML> Wed, 18 Jun 2014 09:43:28 GMT https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700604#M252880 MK_QSL 2014-06-18T09:43:28Z Re: Positive and negative values in Pie Chart https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700605#M252881 <HTML><HEAD></HEAD><BODY><P>You cann't represent negative values in pie chart. Instead you use color coding for text or pie for negative values.</P></BODY></HTML> Wed, 18 Jun 2014 09:47:50 GMT https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700605#M252881 manojkulkarni 2014-06-18T09:47:50Z Re: Positive and negative values in Pie Chart https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700606#M252882 <HTML><HEAD></HEAD><BODY><P>Logically it doesn't make sense to have a fabs slice on a pie chart unless all your values were negative, all you are doing is under proportioning the counterweight. </P></BODY></HTML> Wed, 18 Jun 2014 09:48:12 GMT https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700606#M252882 2014-06-18T09:48:12Z Re: Positive and negative values in Pie Chart https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700607#M252883 <HTML><HEAD></HEAD><BODY><P>I suggest using a stacked bar chart instead of a pie chart.</P></BODY></HTML> Wed, 18 Jun 2014 09:54:31 GMT https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700607#M252883 Anonymous 2014-06-18T09:54:31Z Re: Positive and negative values in Pie Chart https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700608#M252884 <HTML><HEAD></HEAD><BODY><P>As others have stated, a pie chart isn't really the best option because it cannot show negatives and positives together on one pie.</P><P></P><P>You could, however, create two expressions and group them so the user can switch between positive results and negative results using the cyclic button.</P><P></P><P>EXPR1 - Positives: RangeMax(Value,0)</P><P>EXPR2 - Negatives: RangeMin(Value,0)</P><P>This works best when there is a legend with numbers showing and the Suppress Zero Values option unchecked.</P><P></P><P>flipside</P></BODY></HTML> Wed, 18 Jun 2014 10:16:32 GMT https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700608#M252884 flipside 2014-06-18T10:16:32Z Re: Positive and negative values in Pie Chart https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700609#M252885 <HTML><HEAD></HEAD><BODY><P>Thanks to all of you, but I think this works the best. </P></BODY></HTML> Wed, 18 Jun 2014 11:28:38 GMT https://community.qlik.com/t5/QlikView/Positive-and-negative-values-in-Pie-Chart/m-p/700609#M252885 2014-06-18T11:28:38Z