topic Format Numbers To Integer in QlikView

Format Numbers To Integer

Mon, 13 Feb 2012 23:03:14 GMT

Hello,

Apologize as this might be a simple question. I'm trying to format numbers in Edit Script so that float numbers is converted to Integer. Which function does this trick?

Your help is much appreciated!

Format Numbers To Integer

Mon, 13 Feb 2012 23:08:37 GMT

Round( value)

Ceil ( value)

Floor( value)

Format Numbers To Integer

swuehl — Mon, 13 Feb 2012 23:11:08 GMT

If you only want to format the field, but keep the floating point number internally, use

...

num(FIELD,'0') as FIELD,

...

If you want to keep only the integer part, use

floor(FIELD) as FIELD,

...

to truncate to integer

...

round(FIELD,1) as FIELD

...

for a rounded integer.

Hope this helps,

Stefan