topic Pie chart - combining numeric and % age amount in QlikView

Pie chart - combining numeric and % age amount

Thu, 11 Dec 2014 10:33:22 GMT

Hi - I have a pie chart with no dimensions but two set analysis expressions which basically form the two slices of my pie. I want to now show the %age amounts for these too not just the numeric amount.

What would be the best way to go about this ? ( I could create new expressions to show the % age amounts but then they are treated separately and are not displayed under the original numeric amounts ).

Thanks

Re: Pie chart - combining numeric and % age amount

yduval75 — Thu, 11 Dec 2014 11:11:09 GMT

In your expressions, you can use Dual function with

Dual (Yourexpresisionnuméric & Your expressionpercentage, yourexpression)

Re: Pie chart - combining numeric and % age amount

rajeshvaswani77 — Thu, 11 Dec 2014 11:12:54 GMT

Please check this blog post of mine

http://qlikdesign.wordpress.com/2013/05/29/pie-chart-having-both-values-and-percentages/

thanks,

Rajesh Vaswani

Re: Pie chart - combining numeric and % age amount

Anonymous — Thu, 11 Dec 2014 15:41:15 GMT

Also you can try 2 expressions on a pie chart with one of them showing numbers in legend and one of them showing on slices.

Serhan

Re: Pie chart - combining numeric and % age amount

Tue, 16 Dec 2014 16:17:51 GMT

Thanks for the replies. So using the dual function on both of my expressions I now successfully have the amount and percentage (displayed in brackets). However the two slices of the chart are not displaying proportionately. One is 25% and one is 75% but the slices are showing as equal halves.

Any ideas ?