Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
dineshkumar
New Contributor III

pie chart value coincides

how to avoid overlapping of values in pie chartpiechart.PNG

Tags (1)
1 Solution

Accepted Solutions
raajaswin
Contributor III

Re: pie chart value coincides

Follow these steps to create a pie chart with staggered labels:

1. Create a new pie chart.

2. Add your dimension.

3. On the Expressions tab, add the following expression:

Dual(

Dimension & '-' &

Num(Measure, '#,##0') &

Repeat(chr(13)&chr(10), rank(Measure)-6),

Measure

)

4. Select the Values on Data Points option.

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

the direction.

6. On the Presentation tab, deselect the Show Legend option

View solution in original post

5 Replies
Partner
Partner

Re: pie chart value coincides

If u are facing this issue.we have one more way too.

GOTO >> Properties>Enable Show Numbers in Legend.

Partner
Partner

Re: pie chart value coincides

If you are not reaching your requirement.

Share sample file ?

raajaswin
Contributor III

Re: pie chart value coincides

Follow these steps to create a pie chart with staggered labels:

1. Create a new pie chart.

2. Add your dimension.

3. On the Expressions tab, add the following expression:

Dual(

Dimension & '-' &

Num(Measure, '#,##0') &

Repeat(chr(13)&chr(10), rank(Measure)-6),

Measure

)

4. Select the Values on Data Points option.

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

the direction.

6. On the Presentation tab, deselect the Show Legend option

View solution in original post

Highlighted
raajaswin
Contributor III

Re: pie chart value coincides

good to hear it worked for u

Not applicable

Re: pie chart value coincides

Hi there

My Expression:

Dual(

Ded_Description & '-' &

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

Repeat(chr(13)&chr(10), rank(sum(EFT_Volume))-6),

sum(EFT_Volume)

)

My Graph

Capture.PNG

Please assist