Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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