topic Rounding in QlikView

Rounding

Fri, 18 Jan 2013 16:44:47 GMT

Hi All,

I am working with a straight table where i need to round some values from

100,000,000.00 to 100.00

AND

if value is only two decimal palaces 0.11 no action is needed.

How can I work this into a formula?

Thank you

Re: Rounding

Fri, 18 Jan 2013 16:54:31 GMT

Hi,

Try something like this:

=num(sum(Expression),0.00)

Regards,

-Khaled.

Re: Rounding

Fri, 18 Jan 2013 16:58:08 GMT

Pl upload the application

Re: Rounding

shree909 — Fri, 18 Jan 2013 17:42:50 GMT

Try this

=round(sum(Expression),0.01)

it will round the values and display with 2 decimals

or if u want to list the first 2 decimals.

Goto the properties tab, select numbers theere u can modify the values accordingly..

or =num(sum(Expression),0.01),' #,##0.00') it will exactly return 2 values...

Re: Rounding

Fri, 18 Jan 2013 18:29:40 GMT

That does not work for me. Any other suggestions?

Re: Rounding

shree909 — Fri, 18 Jan 2013 19:11:19 GMT

can u post a sample .so that we can figure out where exactly ur missing?

Re: Rounding

Fri, 18 Jan 2013 19:15:07 GMT

Dear zvirina123,

in the stright table goto Numbers tab and select the Particular expression and in the number format settings select the fixed to 2 decimal.

Thanks,

Mukram.

Re: Rounding

Fri, 18 Jan 2013 19:20:57 GMT

Here you go. Thank you for your help

Re: Rounding

shree909 — Fri, 18 Jan 2013 19:40:12 GMT

where exactly ur getting wrong..

i am able to display for the 2 decimals..

the thing is u marked in numbers as money format..

can u change that to decimal...

Re: Rounding

Fri, 18 Jan 2013 19:59:19 GMT

Now i am getting extra zeros. How can i hide it?