topic Re: Pie Chart Data value points in QlikView

Pie Chart Data value points

narband2778 — Wed, 13 Nov 2013 12:16:51 GMT

Hi guys,

Values of my Pie chart are overlapping. Is there any way where I can insert values in the segments or can we make the numbers vertical.

I know this option "show numbers in legend" but i dnt want to use it.

let me know if we have any option.

thanks in advance

Bandari

Re: Pie Chart Data value points

israrkhan — Wed, 13 Nov 2013 12:40:58 GMT

Try below option, you might like it:

change your expression like below: i used Country as Dimension and Sales as Mear, chang them with your fields.

Dual(Country & '-' & Num(sum(Sales), '#,##0') & Repeat(chr(13)&chr(10), rank(Sum(Sales))-6),sum(Sales))

Select the Values on Data Points option. for expression

On the Sort tab, select the Y-Value option. Confirm Descending as the direction.

On the Presentation tab, deselect the Show Legend option.

hope it helps

Re: Pie Chart Data value points

Wed, 13 Nov 2013 14:51:51 GMT

Hi,

I would suggest hiding the small segments into segment Others (Dimension Limits tab), then if user wants to know their share, he can click on the Others to filtr them only.

Or can you choose a bar chart, which provides basically the same information

Or you can use combination of them. In this case the bar chart will be set to show only those who are included in the Others segment and if the segment is not exist than the bar chart will be disabled. You should play with formatting more 🙂

Long story short I do not know any way not to overlap the data points labels and i offer some workaround.

Regards,

Jan