Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
share sample?
or did u unchk the relative in expression tab of pie chart?
What is your expression?
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
Hi Chanty,
Thanks for ur reply.
I am not using Qlikview, m using Qlik Sense
Thanks,
Muni.
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
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.
with a single selection, that selection is represented by the whole pie, so it's 100%
Andy
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%