topic Re: Rounding off!!!!!!!! in QlikView

Rounding off!!!!!!!!

Fri, 16 May 2014 06:44:18 GMT

HI All,

I have a Expression in that i have Decimal part is there so i want to round off that one Like;

present Input:

CINDEX
74.00156
26.00783

I want to get the this out put:

Cindex
74.1
26.1

can u help me how

thanks

Re: Rounding off!!!!!!!!

Joaquin_Lazaro — Fri, 16 May 2014 06:49:00 GMT

Hi Suneel:

There are some rounding functions

1) Round

2) Ceil = Round Up

3) Floor = Truncate or Round Down

Hope it helps

Joaquin

Re: Rounding off!!!!!!!!

amit_saini — Fri, 16 May 2014 06:50:50 GMT

Hi Suneel,

You this in your expression:

=Num(Your_Field,'##.#')

Thanks,
AS

Re: Rounding off!!!!!!!!

nizamsha — Fri, 16 May 2014 06:52:24 GMT

u can use ceil,round,floor but how u r bringing ur output like that

74.1

Re: Rounding off!!!!!!!!

Joaquin_Lazaro — Fri, 16 May 2014 06:56:03 GMT

The last parameter of this functions is an offset.

You could round/floor/ceil to 0.003 or 0.04 or 0.7

Not only to 0 or to +1

Re: Rounding off!!!!!!!!

Fri, 16 May 2014 06:58:31 GMT

IF it is 74.56217

I want round it to 74.6 like that

Re: Rounding off!!!!!!!!

Joaquin_Lazaro — Fri, 16 May 2014 07:01:06 GMT

round( 2.4 ) returns 2

round( 2.6 ) returns 3

round( 2.5 ) returns 3

round( 3.88 , 0,1 ) returns 3,9

round( 3.88 , 5 ) returns 5

round( 1.1 , 1 , 0.5 ) returns 1,5

Have a look at the online help

Re: Rounding off!!!!!!!!

kogasawara — Fri, 16 May 2014 07:04:32 GMT

try ceil function!!

load ceil(ceil(ceil(Ceil(CINDEX,'0.0001'),'0.001'),'0.01'),'0.1') as CINDEX inline

[

CINDEX

74.00156

26.00783

74.56217

];

Re: Rounding off!!!!!!!!

Fri, 16 May 2014 07:04:38 GMT

Try this,

Ceil(CINDEX,'00.1',1)

-Prabhu

Re: Rounding off!!!!!!!!

Joaquin_Lazaro — Fri, 16 May 2014 07:14:41 GMT

Hi Sunil

If you have 74.01 and you want 75 you must use Ceil

If you have 74.99 and you want 74 you must use Floor

If you have (74.01 to 74.49 and want 74) or (74.50 to 74.99 and want 75) you must use Round

Three functions works with some decimals

Re: Rounding off!!!!!!!!

nizamsha — Fri, 16 May 2014 07:15:11 GMT

Try this one

LOAD * Inline [

Number

80.56

74.456

32.32

];

=num(Number,'##0.0')

Re: Rounding off!!!!!!!!

sunilkumarqv — Fri, 16 May 2014 07:58:48 GMT

Use you expression like these

= Num(Expresssion,'#,##0.0;(#,##0.0); ')

= Num(Expresssion,'#,##.#;(#,##.#);')

Re: Rounding off!!!!!!!!

Anonymous — Fri, 16 May 2014 08:10:14 GMT

why don't you simply change in the number format tab and change that to 1 decimal place fixed?

Re: Rounding off!!!!!!!!

ankitaag — Thu, 23 Apr 2015 11:51:16 GMT

Hello,

Try Num(CINDEX,'##0.0')

It will round to 1 decimal value

Thanks and Regards,

Ankita

Re: Rounding off!!!!!!!!

buzzy996 — Thu, 23 Apr 2015 11:57:33 GMT

use Ceil()