Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

convert a float field to integer

Hello, everyone.

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

this is my field

Captura.JPG

Thanks,

Regards.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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,'#,#',',','.'))

View solution in original post

7 Replies
Highlighted
MVP
MVP

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

Highlighted
Specialist
Specialist

Now , try it but did not work.


Num#(ABAST,'0.0')

Num(ABAST,0)

Num(ABAST)

Rount(ABAST)

Floor(ABAST)

and CEIL(ABAST)



Highlighted
MVP
MVP

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

Highlighted
Specialist
Specialist

Of course, thanks.


Highlighted
MVP
MVP

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,'#,#',',','.'))

View solution in original post

Specialist
Specialist

Thank you very much swuehl , is working perfect.

Regards.

Highlighted
Contributor II
Contributor II

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.