topic Re: Pie chart tool tip with $ and % in QlikView

Pie chart tool tip with $ and %

Tue, 23 Aug 2011 18:09:19 GMT

Hello,

I am creating an QV 9.0 SR5 application. I have a pie chart and want to show the slices with their relative dollar amounts and percentages.

This is what I have right now:

What I want is to show the % and the dollar amount that the slice has, which is my chart's Expression.

Is that possible and if so, how do I do it?

Thanks!

Pie chart tool tip with $ and %

its_anandrjs — Tue, 23 Aug 2011 18:49:14 GMT

Hi,

Yes it is possible as you say you want to display % in $ you need to set is number properties.

Regards,

Anand

Pie chart tool tip with $ and %

its_anandrjs — Tue, 23 Aug 2011 18:53:31 GMT

Hi,

You need to set the chart properties from Number properties from Fixed to change it Money and put $ symbol in the Symbol text box. By this you are able to change the setting from % to $.

If you has any sample so please share it.

Regards,

Anand

Re: Pie chart tool tip with $ and %

Tue, 23 Aug 2011 19:01:59 GMT

Thank you for your help with this.

I can make the change you suggested but I will then have just the dollar amounts. I am trying to find a way to have both percentage and dollar amount on the tooltip at the same time.

Please see the sample application attached. It shows the dollar amount as you suggested. Is there a way to add the percentage in there without losing the dollar amount?

Thank you,

Peter

Re: Pie chart tool tip with $ and %

its_anandrjs — Tue, 23 Aug 2011 19:10:33 GMT

Hi,

You are right on this application it is display according what you discuss. Now please see the sample file i do some changes on that, it is ok for you. Please confirm me.

Regards,

Anand

Re: Pie chart tool tip with $ and %

Tue, 23 Aug 2011 19:13:29 GMT

Thanks Anand but no, that will not meet the requirement. It looks like you pre-pended a dollar sign onto the percentage. That would be pretty confusing for my users. Thanks for trying anyway!

Does this mean there is no way to do what I want, everyone?

Re: Pie chart tool tip with $ and %

Tue, 23 Aug 2011 19:17:36 GMT

Aha! I just figured this out myself. I just had to add additional Expressions for each new label I wanted to see. Makes sense, once you think of it.

I am attaching a new version of the sample application so anyone else with this problem will see how I solved this.

Peter