Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Avoiding overlapping of Values on Data Points

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

Capture.JPG

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?

3 Replies
qlikmsg4u
Specialist
Specialist

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

Properties > Presentation > Legend > Show Numbers in Legend

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi

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

AbhijitBansode
Specialist
Specialist

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.