Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rathnam_qv
Creator
Creator

Pie chart issue

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.

8 Replies
Chanty4u
MVP
MVP

share sample?

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

sunny_talwar

What is your expression?

Not applicable

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
Creator
Creator
Author

Hi Chanty,

Thanks for ur reply.

I am not using Qlikview, m using Qlik Sense

Thanks,

Muni.

awhitfield
Partner - Champion
Partner - Champion

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
Creator
Creator
Author

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
Partner - Champion
Partner - Champion

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

Andy

Not applicable

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%