topic Function in QlikView

Function

renuka_sasikumar — Wed, 05 Mar 2014 08:09:28 GMT

What is the function used to show 2.3 as 3.

Re: Function

Siva_Sankar — Wed, 05 Mar 2014 08:11:59 GMT

Round(2.3)

Regards.

Siva

Re: Function

arulsettu — Wed, 05 Mar 2014 08:16:12 GMT

use round of function...

Re: Function

MK_QSL — Wed, 05 Mar 2014 08:17:35 GMT

round( x [ , base [ , offset ]])

Rounding of x upwards or downwards to the nearest multiple of base with an offset of offset. The result is a number. If x is exactly in the middle of an interval, it is rounded upwards.

Examples:

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

Re: Function

Wed, 05 Mar 2014 08:20:50 GMT

frac() returns the decimal part

floor() returns the integer part

frac(x)+floor(x) = x

Fabrice

Re: Function

NavinReddy — Wed, 05 Mar 2014 08:23:36 GMT

=Ceil(2.3) try this

Re: Function

Wed, 05 Mar 2014 08:24:50 GMT

hi try this

ceil( 2.3 ) returns 3

Re: Function

Wed, 05 Mar 2014 11:01:52 GMT

hi Renuka,

i think u got Answer for your question so please mark this question As answered by choosing Correct answer

so it will help others also

those who are searching for same type Of Qustions

Re: Function

jagan — Wed, 05 Mar 2014 11:05:39 GMT

Hi,

Try

Ceil(Number)

Regards,

Jagan.

Re: Function

amit_saini — Wed, 05 Mar 2014 11:08:36 GMT

Hi Renuka,

Try this :

Ceil(Your_Field) as Your_number

Thanks