Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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?
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