Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
MarcoARaymundo
Creator III
Creator III

Pie chart overlay subtitles. How to solve?

Hi! any ideia?

pie chart.png

8 Replies
Aurelien_Martinez
Partner - Specialist
Partner - Specialist

Hi,

I think you can add dimension limites (with "Show Others" option) to restrict to 4 or 5 segments. Or change to a bar chart.

Regards

Aurélien

Help users find answers! Don't forget to mark a solution that worked for you!
bill_markham
Champion III
Champion III

Marco

Some people whom I hold in high regard [and agree with] believe that Pie Charts are ineffective visualisation.

A simple table or bar chart could well be visually more effective at conveying the meaning & implications of the data.

Stephen Few is well known for his work on visualisation, I suggest you google Stephen Few Pie Chart and read his views on the matter.

Best Regards,     Bill

MK_QSL
MVP
MVP

From : QlikView For Developers CookBook

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

1. Create a new pie chart.

2. Add Country as the dimension.

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

Dual(

Country & '-' &

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

Repeat(chr(13)&chr(10), rank(Sum(Sales))-6),

sum(Sales)

)

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.

javier_florian
Creator III
Creator III

Try with Ctrl + Alt to resize your graphs

Not applicable

Hi Marco,

Like best practice in data visualization for a pie chart, You could show 4 or 5 elements and use the option Others.

Chart properties --> Dimention limits --> Options -> Show Others.

Regards,

MarcoARaymundo
Creator III
Creator III
Author

Tks Aurélien Martinez, i know that, but, my client not like.

MarcoARaymundo
Creator III
Creator III
Author

Tks, Bill!

I liked this (http://www.perceptualedge.com/articles/08-21-07.pdf) article, very usefull. I read, but, i need more time to apply in my applications.

MarcoARaymundo
Creator III
Creator III
Author

Tks! I will try this.