topic Re: Pie Chart not showing values properly? in QlikView

Pie Chart not showing values properly?

Rajesh — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i trying to create Pie chart, some values are not showing properly can any one suggest how to show properly

please see below pie chart for your reference

Thanks in advance

Rajesh

Re: Pie Chart not showing values properly?

Chanty4u — Fri, 04 Aug 2017 05:42:00 GMT

you will get some help from below thread

Pie chart not showing properly

Re: Pie Chart not showing values properly?

avinashelite — Fri, 04 Aug 2017 05:47:51 GMT

The values are showing properly but its overlapping , if you observe all the values at the lower range are overlapping because they don't have the space to show the complete values properly ...other two values have good space and hence the numbers are visible . Better hide the value on data points and show only in the legend

Hope this helps you .

Re: Pie Chart not showing values properly?

neha_shirsath — Fri, 04 Aug 2017 05:58:08 GMT

Below links will help you-

https://community.qlik.com/thread/29055

Reposition Pie Chart data point values?

https://community.qlikview.com/thread/236670

Re: Pie Chart not showing values properly?

Nagaraju_KCS — Fri, 04 Aug 2017 06:05:28 GMT

Have a look...

Mapt - Developer skills delivered

Re: Pie Chart not showing values properly?

jonathandienst — Fri, 04 Aug 2017 06:15:47 GMT

If exact values need to be visualised, you are better off using a bar chart than a pie.

You usually do not need much detail for the 'rats and mice" , so you could:

Conditionally hide the small values (click + next to the expression and enter a condition under show values.
Use Dimension Limits to group the small value into 'Others'.

Re: Pie Chart not showing values properly?

Rajesh — Fri, 04 Aug 2017 06:41:11 GMT

Thanks all for your value suggestions

Staggering labels not working in this, may be my dimension have 5 values only.

Re: Pie Chart not showing values properly?

Nagaraju_KCS — Fri, 04 Aug 2017 08:24:48 GMT

Stagger labels working for me..

Try Once...

Dual(

Num(SUM(Expression), '#,##0') &

Repeat(chr(13)&chr(10), rank(SUM(Expression))-2),

SUM(Expression)

)

Re: Pie Chart not showing values properly?

Rajesh — Fri, 04 Aug 2017 10:00:17 GMT

Thank you Raju..

its working now as expected.

Re: Pie Chart not showing values properly?

Fri, 04 Aug 2017 10:48:23 GMT

U can try Staggering labels but if u really want to show values instead of percentages better go for bar-chart. Pie charts are meant to show percentages.