topic Re: Pie chart Question in QlikView

Pie chart Question

Thu, 18 Oct 2012 15:08:42 GMT

Hello

I have successfully built a pie chart to show the percentage of each customers incoming revenue, my problem is :

when I click on one individual customer to see what there revenue percentage is compared to the total, it shows the whole pie as that customer and at 100%, i am wanting to see the percentage of that customer to the total not to itself!!

How can I do that?

Re: Pie chart Question

MayilVahanan — Thu, 18 Oct 2012 15:15:31 GMT

Try like this

=Sum(amount)/Sum({1} total amount)

Hope that helps

Re: Pie chart Question

edg_baltazar — Thu, 18 Oct 2012 15:19:04 GMT

Hello Collen!, that's the way QlikView work's calculating your metrics (in this case the revenue), based on your actual selections , if you want to know the percentage revenue of that client you could make it by this way.... right click on pie chart, go to presentation tab and check 'Pop-Up Labels' box then click ok, now in your chart put the mouse pointer in some part of you pie and then a pop up will appear with the percentage and the client , also you can check the 'Show Legend' and 'Show Numbers in Legend' in the presentation tab.

Hope this Help you!

Re: Pie chart Question

Thu, 18 Oct 2012 15:25:21 GMT

that did not help.it actually made it worse.

Re: Pie chart Question

MayilVahanan — Thu, 18 Oct 2012 15:30:55 GMT

can you upload a sample file?

its show the only selected customer , but not 100 percentage, its show the percentage of that customer compare to overall..

Re: Pie chart Question

Thu, 18 Oct 2012 15:40:13 GMT

Please se the file attached.

The Pie already calculates the percentage on the Total.

If you make a selection that becomes the total and hence the results.

Think for some other ways of displaying your data

Hope this helps

Regards

Mhatim

Re: Pie chart Question

Thu, 18 Oct 2012 15:54:54 GMT

Re: Pie chart Question

Thu, 18 Oct 2012 16:01:56 GMT

did you receive my file?

Re: Pie chart Question

MayilVahanan — Thu, 18 Oct 2012 16:02:06 GMT

check the attached file.

Hope that helps

Re: Pie chart Question

Thu, 18 Oct 2012 16:31:08 GMT

for some reson it is still not showing the selected company as a percentage of the total.

Re: Pie chart Question

MayilVahanan — Thu, 18 Oct 2012 16:37:51 GMT

In expression, untick the relative check box..That helps