topic Re: Value overlapping in Pie Chart in QlikView

Value overlapping in Pie Chart

kenwong1122 — Sat, 16 Nov 2024 00:26:27 GMT

Hi,

I have this Pie Chart, but the value is overlapping.

This is the formula i am using;
[Primary Model Interest] & '-' &
Dual(
num(count({<[Is Revisit]={'FRESH'}>}[Lead Traffic Id]) + count({<[Is Revisit]={'RE-VISIT'}>} [Lead Traffic Id]), '#,##0') &
Repeat(chr(13)&chr(10), rank(count({<[Is Revisit]={'FRESH'}>}[Lead Traffic Id]) + count({<[Is Revisit]={'RE-VISIT'}>} [Lead Traffic Id]))-8),
count({<[Is Revisit]={'FRESH'}>}[Lead Traffic Id]) + count({<[Is Revisit]={'RE-VISIT'}>} [Lead Traffic Id])
)

Please help. Thank you.

Re: Value overlapping in Pie Chart

basav — Tue, 30 Jun 2020 06:36:42 GMT

Hi Ken,

I am not sure if they are chart title or the data that are over lapping. But try this:

press and hold Ctrl+Shift button(for windows) you will see red outlines, then you can adjust the layouts withing the chart.

cheers,

Basav

Re: Value overlapping in Pie Chart

kenwong1122 — Wed, 01 Jul 2020 01:08:50 GMT

Tried it, but still the same...

Re: Value overlapping in Pie Chart

Saravanan_Desingh — Wed, 01 Jul 2020 01:40:42 GMT

If the size is small, then it will overlap. In this case, you should find a way to identify which ones are overlapping.

Add'\n' in front of the display value to bring it to the next line.

Something like,

display value 1 = '\n'&display value 1

display value 2 = '\n\n'&display value 2

display value 3 = '\n\n\n'&display value 3

I know this is not easy. But its my way of doing.

Re: Value overlapping in Pie Chart

kenwong1122 — Wed, 01 Jul 2020 01:59:21 GMT

By Display value, what do you mean adding '\n'?
Add in front of the expression? then it would merely show \n in front of the value on the data points

Re: Value overlapping in Pie Chart

Saravanan_Desingh — Wed, 01 Jul 2020 02:58:47 GMT

The \n is line feed. By adding this you will be adding a new row to the display value.

Re: Value overlapping in Pie Chart

kenwong1122 — Mon, 06 Jul 2020 01:54:14 GMT

Hi,

Apparently only those with similar value, i.e, 2 model having same value, 1, would overlap with one another, is there a solution on this?