Pie chart issue

[rathnam_qv]

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.

[Chanty4u]

share sample?

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

[sunny_talwar]

What is your expression?

[#4]

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

[rathnam_qv]

Hi Chanty,

Thanks for ur reply.

I am not using Qlikview, m using Qlik Sense

Thanks,

Muni.

[awhitfield]

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

[rathnam_qv]

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.

[awhitfield]

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

Andy

[#9]

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%