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: 
Anonymous
Not applicable

rounding off percentage values

i have a value in percentage displayed as :

123456.89%

i want to round off to 12.89%(eg two digits) ,how to do that?

3 Replies
MK_QSL
MVP
MVP

How you are getting 123456.89%??? if you are using any expression, you can do something like below

Num(YourExpression , '#0.00%')

Something like below

Num(SUM(Sales)/SUM(Total Sales) , '#0.00%')

qlikcheepirishe
Creator
Creator

Round(123456.89%)

then change in number format.It will round it off as your requirement.

kennethmash
Contributor III
Contributor III

I don't fully understand your requirement but if you are using a chart you can go to the Number tab in the properties, select the "Fixed to" option and specify 2 decimal places and tick the Show in Percent option. That might give you what you are looking for