topic Re: Pie chart - overlapping labels in QlikView

Pie chart - overlapping labels

zagzebski — Sat, 30 Sep 2017 16:11:39 GMT

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?

Re: Pie chart - overlapping labels

Sergey_Shuklin — Sat, 30 Sep 2017 16:27:55 GMT

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.

Re: Pie chart - overlapping labels

zagzebski — Sat, 30 Sep 2017 16:35:56 GMT

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

Steve

Re: Pie chart - overlapping labels

Sergey_Shuklin — Sat, 30 Sep 2017 17:12:39 GMT

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

Re: Pie chart - overlapping labels

Sergey_Shuklin — Sat, 30 Sep 2017 19:15:44 GMT

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

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];

Re: Pie chart - overlapping labels

vishsaggi — Sun, 01 Oct 2017 00:40:48 GMT

Check here: Pie Chart visualization: Overlapping values

Using a repeat function you can move labels up.