topic Avoiding overlapping of Values on Data Points in QlikView

Avoiding overlapping of Values on Data Points

Anonymous — Fri, 31 Jul 2015 05:27:12 GMT

I have this pie chart where the values on data points are overlapping with one another.

Say for example if the same happens in Bar Chart, we can change the orientation of label to Vertical or Horizontal based on the requirement. Unfortunately I can't find anything similar in Pie Chart.

Is there a hack to do this?

Re: Avoiding overlapping of Values on Data Points

qlikmsg4u — Fri, 31 Jul 2015 05:37:29 GMT

one better way is remove values on data points and display numbers in legend

Properties > Presentation > Legend > Show Numbers in Legend

Re: Avoiding overlapping of Values on Data Points

nagarjuna_kotha — Fri, 31 Jul 2015 05:47:43 GMT

PFA....

and one more way is also there to avoid this I.E using Other charts like Bar chart .i have shown you in attachment.

Kindly let me know ur status.

Regards,

Nagarjuna

Re: Avoiding overlapping of Values on Data Points

AbhijitBansode — Fri, 31 Jul 2015 05:53:06 GMT

Turn off values as pop up option in Presentation Tab:

Select the Values on Data Points option.

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

On the Presentation tab, deselect the Show Legend option.

Use dual function in expression:

lets say you want to sum sales i.e. Sum(Sales)

Dual(

Country & '-' &

Num(sum(Sales), '#,##0') &

Repeat(chr(13)&chr(10), rank(Sum(Sales))-3),

sum(Sales)

)

The ASCII characters 13 and 10 give us a carriage return and line feed. Note that there is a Rank()-3 here. Basically, the repeat doesn't kick in until you get to the fourth ranked value in the dimension. There is no reason to start staggering for the earlier values.