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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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')