Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Pie chart - overlapping labels

I am having a problem with Pie chart labels. Just one of many examples below. Is there any trick to not having labels overlap without changing the overall size of the pie chart object?

5 Replies
Sergey_Shuklin
Specialist
Specialist

Hello, Steve!

You can use Replace() function for replacing spaces to chr(13) in your labels.

Or you can load another field with short labels for this case.

zagzebski
Creator
Creator
Author

Thanks for the reply. I am not sure I understand:  Replace() function for replacing spaces to chr(13) in your labels

Steve

Sergey_Shuklin
Specialist
Specialist

I meant to use this expression:

dual(replace(field,' ',chr(13)),sum(val))

but it looks like for pie chart it doesn't work, unlike other charts =/

my apologizes

but, you still have an option to create a short-names field and use it instead of long-names parent

Sergey_Shuklin
Specialist
Specialist

If you upgrade your version of QV to 12 you'll be able to use replace() function:

pie_chart.png

The script:

LOAD * Inline

[piece, val

Aaaaa aaaaaa aaaaa,10

Bbbbbbb bbbbbbbbb,15

Cccccc cccccc cccc,3

Dddd dddddd dddddd,3

Eeeeee eeeee eeeee,25

Fffffff fffffffff,20

Ggggg ggggggggggg,15

Hhhhhhh hhhh hhhhh,12];

vishsaggi
Champion III
Champion III

Check here: Pie Chart visualization: Overlapping values

Using a repeat function you can move labels up.