Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
check the attached file.
Hope that helps
Hi
Try like this
=Sum(amount)/Sum({1} total amount)
Hope that helps
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!
that did not help.it actually made it worse.
HI
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..
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
did you receive my file?
Hi
check the attached file.
Hope that helps
for some reson it is still not showing the selected company as a percentage of the total.