How to show both number and percentage value on a Pie chart in QlikView
I'm trying to display values on data points on a pie chart in both number and relative percentage but i'm only able to achieve one of them. So, either i'm able to show the values in number or in percentage but my task is show it in both simultaneously, I thought of using text object with the expression in it but that won't work as the placement of the object will be static and when data changes or if user do some selections then it won't make any sense.
Is there anyway to achieve this in QlikView?
Any help or suggestions will be hugely appreciated.Sample chart attached below
Thanks for the solution Jens. Even I'm very new this tool.I have done exactly what you have mentioned and it works nicely. Just facing another problem though. Size of the Donut just keeps on changing based on the user selection.
I had a look around but I couldn't really find a solution as simple as checking a 'static size' box or anything unfortunately...
Since the chart seems to get smaller to make space for the labels, one option would be to simply make the chart big or small enough to fit all the labels regardless of selection (So either big enough to the point where the largest labels don't reduce the size of the chart or big enough so any label reduces the size of the chart and it's permanently small).
Keep in mind that you might be able to reduce the size of your labels by limiting decimals or (if your values are very large) by showing your values x1000 or something like that, or by changing the font size.
Another solution would be to move your legend around by clicking on the chart and holding ctrl+shift. Some red lines will show that allow you to resize the individual parts of your chart. You could also limit the length of your legend in Chart properties > Presentation tab > Limit legend (characters).
Hope this helps you. Remember to mark a comment as the correct answer if your question was answered