topic Re: Multiple Percentages Showing In Pie Chart Pop-Up in QlikView

Multiple Percentages Showing In Pie Chart Pop-Up

billbois — Mon, 25 Jun 2012 14:48:40 GMT

I have a pie chart showing the revenue for our biggest clients. When I hover my mouse pointer over the first slice, it shows the client's name, their total revenue, and what percent of our total revenue they represent. That's exactly what I want.

However, when I hover over the second slice, it again shows the client's name and revenue, but it shows the first client's percentage as well as the second client's percentage. Hovering over the third slice show the percentages for each of the first three clients, and so on.

So the pop-ups look something like this:

1st Slice

Client = Acme, Inc.

Revenue = $7,123,456

35.76%

2nd Slice

Client = XYZ Corp.

Revenue = $5,232,123

35.76%

26.26%

3rd Slice

Client = Ajax Widgets

Revenue = $3,451,789

35.76%

26.26%

17.47%

Hovering over, say, the 7th slice, shows 7 percentages. How can I get it to show only the percentage for the slice I'm hovering over? I've tried searching for anyone else who's having this problem, without luck. Thanks in advance!

Re: Multiple Percentages Showing In Pie Chart Pop-Up

Mon, 25 Jun 2012 15:18:02 GMT

Hi Bill,

Can you give a try by unselecting Text as pop-up in epression setting of the chart and selecting pop-up labels in presentation settings of ur chart.

Hope this helps.

thank you

Meher

Re: Multiple Percentages Showing In Pie Chart Pop-Up

billbois — Mon, 25 Jun 2012 15:35:04 GMT

Hi Meher,

I think you may be close, but unfortunately that made the percentages disappear altogether. I've tried a couple combinations of having one checked and the other not, but the only way I get the Client, Revenue and Percent to all display is to have both checked.

Interestingly, I don't have "Text as Pop-Up" checked for my Revenue expression. I tried checking it and that made Revenue duplicate in the pop-ups, too. I think you're on to something, so I'll keep playing around with it.

Thanks,

Bill

Re: Multiple Percentages Showing In Pie Chart Pop-Up

Mon, 25 Jun 2012 15:38:05 GMT

Thank you Bill,

I'll try to look at the issue.

Mean-while please let us know if you find the solution.

thank you

Meher

Re: Multiple Percentages Showing In Pie Chart Pop-Up

christian77 — Mon, 25 Jun 2012 15:46:39 GMT

It happens to me too.

I did what Merwan said.

I still have all those values. First slice, one value, 2nd, two values, 3rd, threee values ...

Re: Multiple Percentages Showing In Pie Chart Pop-Up

Mon, 25 Jun 2012 15:51:52 GMT

Hi Christian 77,Bill Bois.

If possible Can anyone of you send me your application which helps me alot to sort what's happening.

& can you tell me which version you people are using.

thank you

Meher.

Re: Multiple Percentages Showing In Pie Chart Pop-Up

billbois — Mon, 25 Jun 2012 16:01:53 GMT

Sure. I just slapped this one together. Hope it helps!

Re: Multiple Percentages Showing In Pie Chart Pop-Up

Mon, 25 Jun 2012 16:08:21 GMT

Hi Bill,

I just checked the application but it seems fine for me.

Can you tell me which version you are using.

thank you

Meher

Re: Multiple Percentages Showing In Pie Chart Pop-Up

christian77 — Mon, 25 Jun 2012 16:10:51 GMT

Hi:

Another example. QV 11 11282.0, SR 1 64 BIT

The lable on the center pie should be added, like in the legend.

Thanks for your help.

Re: Multiple Percentages Showing In Pie Chart Pop-Up

billbois — Mon, 25 Jun 2012 16:13:52 GMT

Oh yeah, I forgot to tell you about the version. It's 11.00.11282.0 SR1 64-bit.

Your screen shot shows exactly what I get when hovering over the first slice. Here's a shot of hovering over the fourth one. See the list of percenages at the end? They're the percentages of each of the previous slices.

Thanks for following up on this!

Re: Multiple Percentages Showing In Pie Chart Pop-Up

Mon, 25 Jun 2012 17:24:58 GMT

Hi Bill,

May be it's a bug which needs to be fixed.

If it's can you report it.

which helps others, if at all, if someone didn't reported until now.

thanks

Meher

Re: Multiple Percentages Showing In Pie Chart Pop-Up

billbois — Mon, 25 Jun 2012 17:27:33 GMT

Will do, though I'll keep my fingers crossed that someone knows a way around it.

Thanks again,

Bill

Re: Multiple Percentages Showing In Pie Chart Pop-Up

billbois — Tue, 26 Jun 2012 15:36:27 GMT

Yup, it's a known bug, ID #45331. I contacted support and it will be fixed in SR2, though its release has not been scheduled yet.

Thanks for the input, everyone!