topic Show Subtotal In Pie Chart? Possible? in QlikView

Show Subtotal In Pie Chart? Possible?

Wed, 17 Mar 2010 15:15:28 GMT

Hi guys,

Has anyone found an easy way of showing the total all records shown in a pie chart? I have a pie chart with the numbers shown alongside the legend. typically, I would like to show the sum of the numbers in the legend. I know I could create a text box but i am supressing nulls etc in my chart so I don;t think it would be the most efficient method. Any Ideas?

Thanks,

Show Subtotal In Pie Chart? Possible?

Mon, 16 Aug 2010 21:18:38 GMT

bcolgan85 I've run into the same challenge and can't figure out an elegant solution to this. See below, like you said you can add a text box but that's not going to dynamically format like a total of all records. Any suggestions from the community other than a text box would be appreciated. Thanks

Show Subtotal In Pie Chart? Possible?

johnw — Mon, 16 Aug 2010 21:39:00 GMT

Well, I'm not sure it's elegant, but on the presentation tab, you can add text in chart, with an expression like:

='Total = ' & sum(Value)

Then control shift the chart and drag the total wherever you want it. It's still text, but at least it's part of the chart.