topic Re: Pie chart issue in App Development

Pie chart issue

rathnam_qv — Wed, 20 Apr 2016 09:22:24 GMT

Hi All,

I have pie chart with 4 regions showing %value (having % like 21%,23%, 11%, 45%).

Issue is: when I select something in bar chart....the related pie chart value is showing 100% which is wrong.

I want to display its actual % (Ex: if it is 21% want to display the same).

How to do it?

Thanks,

Muni.

Re: Pie chart issue

Chanty4u — Wed, 20 Apr 2016 09:24:26 GMT

share sample?

or did u unchk the relative in expression tab of pie chart?

Re: Pie chart issue

sunny_talwar — Wed, 20 Apr 2016 09:24:38 GMT

What is your expression?

Re: Pie chart issue

Wed, 20 Apr 2016 09:42:14 GMT

Hi Muni,

If you don't want your pie chart to change on selection, try this expression in your Measure of Pie chart.

Sum({1}[YourMeasure])

Regards,

Rohan

Re: Pie chart issue

rathnam_qv — Wed, 20 Apr 2016 11:35:01 GMT

Hi Chanty,

Thanks for ur reply.

I am not using Qlikview, m using Qlik Sense

Thanks,

Muni.

Re: Pie chart issue

awhitfield — Wed, 20 Apr 2016 11:44:30 GMT

It's not wrong it's showing the % of the selected items rather than the total, select more than one and you'll see what I mean

Re: Pie chart issue

rathnam_qv — Wed, 20 Apr 2016 12:45:36 GMT

Hi Andrew,

Yes, what your saying is right. But , if I select only one it is showing 100%.

why it is not working for Single value?

Thanks,

Muni.

Re: Pie chart issue

awhitfield — Wed, 20 Apr 2016 13:27:46 GMT

with a single selection, that selection is represented by the whole pie, so it's 100%

Andy

Re: Pie chart issue

Wed, 20 Apr 2016 13:40:40 GMT

You could change your measure so the value is the %

e.g. COUNT(<Dimension>) / COUNT(ALL <Dimension>)

then change the Properties of the Pie Chart: Presentation > Value Labels > Values

That way it will show the appropriate % instead of 100%