topic rounding off percentage values in QlikView

rounding off percentage values

Anonymous — Fri, 23 Jun 2017 08:22:22 GMT

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?

Re: rounding off percentage values

MK_QSL — Fri, 23 Jun 2017 08:27:36 GMT

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%')

Re: rounding off percentage values

qlikcheepirishe — Fri, 23 Jun 2017 09:09:27 GMT

Round(123456.89%)

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

Re: rounding off percentage values

kennethmash — Fri, 23 Jun 2017 09:43:20 GMT

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