Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
manozpph
Creator
Creator

I want to display expression values in percentage format on Chart

Hi,

I have a Pie chart with Sum(sales) as expression displaying values(68.12,124.11,132.212.....) in number format.

But I want to change  this format in to percentage.I tried changing the option from my end in properties over number tab,still no change.

Can some one make me an idea how can i see the values the way I want present over chart.....??

Many thanks

1 Solution

Accepted Solutions
avinashelite

I feel your using Sales as diemsion and expression that is the issue ...check the show values on Data points and In presentation tab > Show numbers in legend


That should resolve your issue

View solution in original post

11 Replies
sunny_talwar

Did you try to check 'Relative' on the expression tab of the chart properties?

manozpph
Creator
Creator
Author

Yes.But didn't display values in such format.Thanks

manoj217
Creator III
Creator III

On the Expressions tab, check "Relative" for your expression.

avinashelite

Whats the format your are excepting

manozpph
Creator
Creator
Author

Expression values  Percentage format in right.

manozpph
Creator
Creator
Author

Pie chart.png

Hi,Please find the image.I enable Relative path but still the values presenting same.I'm expecting the values of the sales in percentage on the right of the chart.

avinashelite

What is your dimension here ?? 

avinashelite

I feel your using Sales as diemsion and expression that is the issue ...check the show values on Data points and In presentation tab > Show numbers in legend


That should resolve your issue

manozpph
Creator
Creator
Author

Changed Dimension as Order Id.