topic Re: Pie chart overlay subtitles. How to solve? in QlikView

Pie chart overlay subtitles. How to solve?

MarcoARaymundo — Thu, 24 Oct 2013 18:11:30 GMT

Hi! any ideia?

Re: Pie chart overlay subtitles. How to solve?

Aurelien_Martinez — Thu, 24 Oct 2013 18:16:57 GMT

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

Re: Pie chart overlay subtitles. How to solve?

Anonymous — Thu, 24 Oct 2013 18:18:56 GMT

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

Re: Pie chart overlay subtitles. How to solve?

MK_QSL — Thu, 24 Oct 2013 19:00:41 GMT

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.

Re: Pie chart overlay subtitles. How to solve?

javier_florian — Thu, 24 Oct 2013 19:03:52 GMT

Try with Ctrl + Alt to resize your graphs

Re: Pie chart overlay subtitles. How to solve?

Thu, 24 Oct 2013 19:10:18 GMT

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,

Re: Pie chart overlay subtitles. How to solve?

MarcoARaymundo — Thu, 24 Oct 2013 19:21:28 GMT

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

Re: Pie chart overlay subtitles. How to solve?

MarcoARaymundo — Thu, 24 Oct 2013 19:25:34 GMT

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.

Re: Pie chart overlay subtitles. How to solve?

MarcoARaymundo — Thu, 24 Oct 2013 19:27:43 GMT

Tks! I will try this.