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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
1 Reply
MarcoWedel

Num(field,'000000000')