topic Pie Chart Values are showing only one Character in QlikView

Pie Chart Values are showing only one Character

alec1982 — Tue, 11 Feb 2014 18:48:36 GMT

Hi all,

On Pie Chart I am facing a little issue. On the values around the chart the values must be 46, 27, 7, 25

And I am only seeing the first character as 4,2,7,2. I tried to add one decimal value and the values showed up as (46.,27.,7.,25.) which means the first value from the right is always hidden for some reason..

Is it bug or something wrong on my side?

Let me know your thoughts and it is all appreciated!

Re: Pie Chart Values are showing only one Character

Tue, 11 Feb 2014 20:52:23 GMT

Are you summing the values in the pie? What was the number type before you switched to decimal?

Re: Pie Chart Values are showing only one Character

alec1982 — Tue, 11 Feb 2014 20:57:45 GMT

Yes. I am summing. and the expression is simple and correct. If click on show values next to legends I see the right values. the number was Expression default as I am just counting buildings in city.

the number type: I tried all of them such as Integer and others..

Re: Pie Chart Values are showing only one Character

MK_QSL — Tue, 11 Feb 2014 20:58:16 GMT

Is there any number format you are using? If possible, upload you data file or sample apps.

Re: Pie Chart Values are showing only one Character

Tue, 11 Feb 2014 21:01:30 GMT

Hmm interesting. Uploading a sample would definitely help.

Re: Pie Chart Values are showing only one Character

alec1982 — Tue, 11 Feb 2014 21:20:10 GMT

Hi guys,

Thank you for your help. I am not able to upload sample file as it is data sensitive.

basically, I have the dimension as City, Expression as Count(City) . the number format is set to be expression default.

If I turn show values on legend I see the correct nrs but the values around the pie are cutting of the first value from the right...

Thxs,

Alec

Re: Pie Chart Values are showing only one Character

MK_QSL — Tue, 11 Feb 2014 21:21:57 GMT

CITY as Dimension and COUNT(CITY) as Expression?

Re: Pie Chart Values are showing only one Character

alec1982 — Tue, 11 Feb 2014 21:22:48 GMT

yes..

Re: Pie Chart Values are showing only one Character

MK_QSL — Tue, 11 Feb 2014 21:27:56 GMT

You can attach a sample file !

Re: Pie Chart Values are showing only one Character

Tue, 11 Feb 2014 21:30:43 GMT

So you select "Values on Data Points" from the expressions tab, and the numbers surrounding the pie are cut off by the right-most digit. Then, when you select "Show Numbers in Legend" from the Presentation tab, the number show correctly?

If you click ctrl+shift and try to move the pie or the legend, do the numbers appear? Sometimes also closing and re-opening QV fixes odd and unexpected errors for me.

Re: Pie Chart Values are showing only one Character

alec1982 — Tue, 11 Feb 2014 21:52:05 GMT

Hi,

Values on data point the numbers surrounding the pie are cut off. If i select Show Nrs in Legend the Nrs next to the legend are correct but the nrs around the the pie still have the same issue..

Re: Pie Chart Values are showing only one Character

alec1982 — Tue, 11 Feb 2014 21:52:48 GMT

I cannot attached sample of data. the data are sensitive and cannot publish it

Re: Pie Chart Values are showing only one Character

Tue, 11 Feb 2014 21:54:07 GMT

I think he means you can blind the data - make up fake cities and data just to show us an example of the issue you're experiencing.