topic Re: Pie Chart '%' symbol not displaying when decrease legend font in QlikView

Pie Chart '%' symbol not displaying when decrease legend font

Wed, 06 Nov 2013 17:13:23 GMT

Hi all,

I noticed that when I have a Pie Chart that displays the relative percentages (Chart Properties > Expressions > Relative checkbox and Values on Data Points checkbox), and I decrease the legend font size (Chart Properties > Presentation > Settings > Font), the '%' symbol disappears. Sometimes, the numbers and the '%' symbol disappear all together.

I have found a temporary work-around in which I set the font to 'Tahoma' and one font size smaller than I actually want, then increase the font size, and I will have the right display and legend font size. However, this doesn't work for say, Arial.

Is there a direct fix?

Thanks!

Re: Pie Chart '%' symbol not displaying when decrease legend font

rustyfishbones — Wed, 06 Nov 2013 17:18:51 GMT

Does it happen like this?

Re: Pie Chart '%' symbol not displaying when decrease legend font

Wed, 06 Nov 2013 17:25:30 GMT

Hi Alan,

Yes, the default display when selecting the 'Relative' and 'Values on Data Points' checkboxes are the relative percentages to the 2 decimal places. But it should show the '%' sign. When you decrease the legend font, it looks exactly like your above screenshot, where the '%' symbol disappears.

Re: Pie Chart '%' symbol not displaying when decrease legend font

rustyfishbones — Wed, 06 Nov 2013 17:26:13 GMT

Have you tried holding down CTRL + SHIFT

You will see some red around the objects on the chart

While holding CTRL +SHIFT drag the legend across so it fits on the chart

You should then get

Re: Pie Chart '%' symbol not displaying when decrease legend font

Wed, 06 Nov 2013 17:29:09 GMT

Yes, I've tried that, but the '%' symbol still does not display. The 'Show in Percent' checkbox is checked as well..

Re: Pie Chart '%' symbol not displaying when decrease legend font

rustyfishbones — Wed, 06 Nov 2013 17:30:58 GMT

Can you add the file

Re: Pie Chart '%' symbol not displaying when decrease legend font

rustyfishbones — Wed, 06 Nov 2013 17:35:05 GMT

Irene,

Look at the format pattern you have #,##0% try #.00%

Re: Pie Chart '%' symbol not displaying when decrease legend font

Wed, 06 Nov 2013 17:50:02 GMT

I changed the format but it still did not show the '%' symbol.

The file is attached.

Thanks!

Re: Pie Chart '%' symbol not displaying when decrease legend font

Wed, 06 Nov 2013 19:00:10 GMT

I opened your qvw file. It shows % to me. Just try to recreate new pie chart and see that show up.

Re: Pie Chart '%' symbol not displaying when decrease legend font

Wed, 06 Nov 2013 19:04:31 GMT

Hi Devang,

When creating a new pie chart, the default legend font size is size 9. If I decrease to size 8, the '%' will disappear again. It's a matter of fixing the issue of the disappearing '%' when I decrease the legend font size.

Thanks!

Irene

Re: Pie Chart '%' symbol not displaying when decrease legend font

Wed, 06 Nov 2013 19:37:04 GMT

Did you try recreating? I went down to Font size 6, still it show Number and %. I am not sure what is missing, Don't reduce from presentation and Legend setting, just try reducing Font size from Font tab.

Re: Pie Chart '%' symbol not displaying when decrease legend font

Wed, 06 Nov 2013 19:54:04 GMT

just try to keep same fonts and font size in legend setting and font tab.

it works

and which qlikview version are you using.

Re: Re: Pie Chart '%' symbol not displaying when decrease legend font

rustyfishbones — Wed, 06 Nov 2013 20:11:22 GMT

Hi Irene,

Here is your file, I checked the box to show number in Legend and I also Changed to Expression instead of using relative.

Is this what you need

Regards

Alan

Re: Re: Pie Chart '%' symbol not displaying when decrease legend font

Wed, 06 Nov 2013 20:23:11 GMT

Hi Alan,

Thanks for taking a look at the file. This is a great example. So, if we take your updated file, and I want everything to look the same except the legend font to be size 8 instead of default size 9, I go to Presentation > Settings > Font and select size 8. Now the '%' symbol will still disappear from the chart. How do I prevent the '%' from disappearing when I do this?

Alternatively, as Devang suggested, I change the font size from the Font tab, however you will see that the legend font size does not change, only the font size of the chart labels.

To Nandkishor's point, if I have both locations be size 8, the '%' still does not appear.

Thanks,

Irene

Re: Pie Chart '%' symbol not displaying when decrease legend font

rustyfishbones — Wed, 06 Nov 2013 20:29:37 GMT

Hmmmmm..... I see what you mean

It's a tricky one, maybe it's a bug you have found in which case you can report it to Qlikview

But before you do, let me take another look