Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
dineshkumar
Not applicable

pie chart value coincides

how to avoid overlapping of values in pie chartpiechart.PNG

Tags (1)
1 Solution

Accepted Solutions
raajaswin
Not applicable

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

5 Replies
nagarjuna_kotha
Not applicable

Re: pie chart value coincides

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

GOTO >> Properties>Enable Show Numbers in Legend.

nagarjuna_kotha
Not applicable

Re: pie chart value coincides

If you are not reaching your requirement.

Share sample file ?

raajaswin
Not applicable

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

raajaswin
Not applicable

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