topic Pie Chart -- Percentages in QlikView

Pie Chart -- Percentages

Wed, 08 Feb 2012 19:00:07 GMT

I am converting this report into QV http://screencast.com/t/ChU9xWBA. Does anyone know how to do those percentages. I found where I can add the actual numbers in the legend but the percents are pretty valuable.

Pie Chart -- Percentages

stephencredmond — Wed, 08 Feb 2012 19:41:52 GMT

Hi,

Add a 2nd expression - idential to the first. Tick on the "Relative" check box.

Now, group the two expressions and you will get a cycle button that allows you to change from numbers to %.

Regards,

Stephen

Pie Chart -- Percentages

Wed, 08 Feb 2012 20:02:50 GMT

I got all the way to the group and it worked but I am not sure where this cycle button is that will allow me to choose %

Pie Chart -- Percentages

Wed, 08 Feb 2012 20:28:27 GMT

I found it in the bottome left. Thanks.

Pie Chart -- Percentages

stephencredmond — Wed, 08 Feb 2012 20:30:23 GMT

Yep.

If you hold down Ctrl+Shift, you can click on it and drag it around inside the chart. I often place it to the right of the title.

Regards,

Stephen

Pie Chart -- Percentages

Wed, 08 Feb 2012 20:31:01 GMT

Is there a way to have the percents on the pie chart over the color like in the example http://screencast.com/t/ChU9xWBA

Pie Chart -- Percentages

stephencredmond — Wed, 08 Feb 2012 20:38:05 GMT

I don't believe so. Only in Bar charts.

Have you thought of using a bar chart instead?

You can affect the text popup, but not the value in the chart.

Regards,

Stephen

Pie Chart -- Percentages

Wed, 08 Feb 2012 20:39:32 GMT

That is interesting. But in the example the percent is right on top of the pie section without referencing the legend. Here I can only move the legend. Do you know if it is possile to put 46% on top of the red section(or whatever is applicable).

Pie Chart -- Percentages

stephencredmond — Wed, 08 Feb 2012 21:28:46 GMT

Hi,

Like I said before, I don't believe this is possible on a pie chart.

Regards,

Stephen

Pie Chart -- Percentages

Thu, 09 Feb 2012 23:21:12 GMT

How do I adjust that tooltip that comes up? It has the expression etc in there and I want to make it a bit cleaner.

Pie Chart -- Percentages

stephencredmond — Fri, 10 Feb 2012 10:15:48 GMT

You need to add a new expression and tick on "Text as Popup". Then, on the Presentation tab, turn off "Popup Labels".

Regards,

Stephen