Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
mithunjacob
Partner
Partner

Restriction of numbers to 2 decimals is not working in LOAD

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:

q.png

 

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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
MVP & Luminary
MVP & Luminary

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
Partner
Partner
Author

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