QlikView App Dev

[Anonymous]

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?

[MK_QSL]

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]

Round(123456.89%)

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

[kennethmash]

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