Restriction of numbers to 2 decimals is not working in LOAD

[mithunjacob]

I am trying to restrict a column to 2 decimals in the LOAD statement. However, its not working. I have read the previous posts but no luck for me. Could anyone please let me what could be the the issue? The front end restriction is working fine.

This is what I tried in the LOAD (not working):

num(SPEED,'#,##0.00') as SPEED

Requirement:

[marcus_sommer]

I think you used the wrong field because SPEED isn't Speed else it are two different fields (Qlik is case-sensitive).

- Marcus

[marcus_sommer]

Beside this num() will just format the numbers but the multiple digits will remain. If you want real 2-digits numbers you need to use a rounding-function like: round(FIELD, 0.01).

- Marcus

[mithunjacob]

Thanks for the reply. I just re-named the field for security reasons. Its original name is used with proper case.