Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
dineshkumar
Contributor III
Contributor III

pie chart value coincides

how to avoid overlapping of values in pie chartpiechart.PNG

1 Solution

Accepted Solutions
raajaswin
Creator III
Creator III

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
nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

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

GOTO >> Properties>Enable Show Numbers in Legend.

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

If you are not reaching your requirement.

Share sample file ?

raajaswin
Creator III
Creator III

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

raajaswin
Creator III
Creator III

good to hear it worked for u

Not applicable

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