Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Recovery values with the original formatting

Good morning, I have the following problem:


I access to AS400 to read a numeric field of numeric type with length 9.


When the recovery and read the value from QlikView is not long nine but value is displayed (eg 1, 2, 50, 120, etc.).


How can I automatically add zeros before the number recovered in order to have the length field nine?

Thanks

1 Reply
MarcoWedel

Num(field,'000000000')