topic Cluttered Labes and Data Points in Pie Chart in QlikView https://community.qlik.com/t5/QlikView/Cluttered-Labes-and-Data-Points-in-Pie-Chart/m-p/1045494#M524273 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How to avoid cluttered labels and data points in a pie chart? (****Labels are very long)</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113507_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 03 Feb 2016 21:11:33 GMT rishimessi19 2016-02-03T21:11:33Z Cluttered Labes and Data Points in Pie Chart https://community.qlik.com/t5/QlikView/Cluttered-Labes-and-Data-Points-in-Pie-Chart/m-p/1045494#M524273 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How to avoid cluttered labels and data points in a pie chart? (****Labels are very long)</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/113507_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 03 Feb 2016 21:11:33 GMT https://community.qlik.com/t5/QlikView/Cluttered-Labes-and-Data-Points-in-Pie-Chart/m-p/1045494#M524273 rishimessi19 2016-02-03T21:11:33Z Re: Cluttered Labes and Data Points in Pie Chart https://community.qlik.com/t5/QlikView/Cluttered-Labes-and-Data-Points-in-Pie-Chart/m-p/1045495#M524274 <HTML><HEAD></HEAD><BODY><P>There is a very good solution for this topic into the book <STRONG>QlikView for Developers Cookbook</STRONG> from <A href="https://community.qlik.com/qlik-users/2445">stephen-x.redmond</A> (and many more nice ideas), see also: <A href="https://community.qlik.com/docs/DOC-8898">Books and literature</A>. </P><P></P><P>The core of them is to use a dual-function as expression which offsets the labels with a line-break repeating on their ranking - here a snippet from them:</P><P></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New';">Dual(</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New';">&nbsp; Country &amp; '-' &amp; </SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New';"> Num(sum(Sales), '#,##0') &amp; </SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New';"> Repeat(chr(13)&amp;chr(10), rank(Sum(Sales))-6), </SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New';">&nbsp; sum(Sales)</SPAN></P><P><SPAN style="font-size: 10.0pt; font-family: 'Courier New';">)</SPAN></P><P></P><P>- Marcus</P></BODY></HTML> Thu, 04 Feb 2016 07:13:21 GMT https://community.qlik.com/t5/QlikView/Cluttered-Labes-and-Data-Points-in-Pie-Chart/m-p/1045495#M524274 marcus_sommer 2016-02-04T07:13:21Z