topic Challenge with Text on 2-dimensional pie chart in QlikView

Challenge with Text on 2-dimensional pie chart

Wed, 19 May 2010 17:08:31 GMT

In order to analyse the headcount per business area of a number of companies I created a pie chart with 2 dimensions; actually it is one pie in the centre (business areas) and a doughnut on the outside (companies).
On the data points I show the total numbers. (Expressions, Text on Data Point)

My challenge is:
The totals are OK on the outside dimension (companies) but on the innner dimension (business area) I see numbers that don't make a lot of sense. They are not the sum of all heads of that particular business area of all companies but the headcount of that business area of one of the companies.
Interestingly enough, when I hover above a business area segment the pop-up does show the correct total.

How can I get the displayed text to show the correct business area totals?

Challenge with Text on 2-dimensional pie chart

fernandotoledo — Wed, 19 May 2010 17:58:13 GMT

Instead

try out

Challenge with Text on 2-dimensional pie chart

Thu, 20 May 2010 09:38:38 GMT

Fernando,

Thank you very much for your quick reply.

I want to stick to the pie chart because it shows the relative shares of each of the business areas (responsibilities) / companies (Genpo) more clearly than bars.
See attached image of my current chart.

Here are still 2 questions;

1) Rather than having 3 numbers sitting on one element of the inner pie I would like to see the total represented by that element - that is the numbers which in your example are shown in the legend. Can that be done - and if so, how exactly?

2) How did you get the numbers to display in the legend?

Challenge with Text on 2-dimensional pie chart

fernandotoledo — Fri, 21 May 2010 15:48:34 GMT

1) I think it can´t be done that way, it seems that qlikview uses the most detailed dimension to calculate the "total over datapoints"

2) Check Show values on legend under Properties>Presentation