topic Re: Rounded value (1.6 become 1.0) in QlikView

Rounded value (1.6 become 1.0)

Tue, 01 Apr 2014 14:03:33 GMT

Dear Community,

As we know, we can round the Million to 2 digits by :

num(1600000/1000000 , '#,#') = 1.6

num(1600000/1000000 , '#,0') = 2.0

Any method or function that can make this to 1.0 ?

For example:

xxx(1600000/1000000, 'xxx') = 1.0

xxx(1600000, 'xxx') = 1000000

Thanks and best regards,

Chanel

marcus_sommer — Tue, 01 Apr 2014 14:09:41 GMT

You could use floor() / and ceil() to round down/up.

- Marcus

Tue, 01 Apr 2014 14:20:06 GMT

Hi,

It can be:

Num(Div(1600000,1000000),'#.0')

Makes 1.0. Hope this helps.

Tue, 01 Apr 2014 14:20:34 GMT

Appreciated for your help, Marcus!

Simple but useful solution ^^

Tue, 01 Apr 2014 14:21:39 GMT

Thanks for your response, I have done with Marcus solution above!

=num(floor(1600000/1000000) , '#,#')