topic Re: convert a float field to integer in QlikView

convert a float field to integer

Anonymous — Thu, 05 Nov 2015 22:22:13 GMT

Hello, everyone.

I need help how i can to convert a float field to integer.

this is my field

Thanks,

Regards.

Re: convert a float field to integer

swuehl — Thu, 05 Nov 2015 22:26:07 GMT

Have you tried a rounding function like ROUND(FIELD), CEIL(FIELD), FLOOR(FIELD)?

Re: convert a float field to integer

Anonymous — Thu, 05 Nov 2015 22:30:21 GMT

Now , try it but did not work.

Num#(ABAST,'0.0')

Num(ABAST,0)

Num(ABAST)

Rount(ABAST)

Floor(ABAST)

and CEIL(ABAST)

Re: convert a float field to integer

swuehl — Thu, 05 Nov 2015 22:32:36 GMT

Could you upload a small sample QVW that shows your issue / field?

Re: convert a float field to integer

Anonymous — Thu, 05 Nov 2015 23:05:26 GMT

Of course, thanks.

Re: convert a float field to integer

swuehl — Thu, 05 Nov 2015 23:14:06 GMT

Your ABSAT field is a text field. before you can use numerical functions like rounding functions, you need to interpret it as number, using num#(). When using num#() you need to specify a correct format code and you may need to specify the separators if they differ from your defaults.

This seems to work for me (only one distinct ABSAT value contained in the QVW to test):

round(num#(ABSAT,'#,#',',','.'))

Re: convert a float field to integer

Anonymous — Thu, 05 Nov 2015 23:28:33 GMT

Thank you very much swuehl‌ , is working perfect.

Regards.

Re: convert a float field to integer

FGee — Mon, 26 Aug 2019 12:37:38 GMT

A round function works pretty well for your problem. Other useful functions are the ceil and floor function depending on how exactly you would want to manipulate your data.