Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

how to append zero in the front of the data of the feild

i have delivery number . And this delivery number sometimes will have 9 digits , 8 digits or 7 digits. But i want the end column data should have as 10 digits with zeros in the front .

For example if i have

1234567--- output:  0001234567

12345678-- output: 0012345678

1234567891--- since it is 10 digits it should not change.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

If it is text, try

=num(num#(field),'0000000000')

View solution in original post

9 Replies
Clever_Anjos
Employee
Employee

NUM(field,'0000000000')

maxgro
MVP
MVP

=num(12345678, '0000000000')

=num(yourfield, '0000000000')

or here

1.png

Anonymous
Not applicable
Author

when i tried this . I am getting null values. Do you think because the format of the field is in text format.

Anonymous
Not applicable
Author

Thank you Massimo. But i am getting null values. Let me attached the QVW file.

Clever_Anjos
Employee
Employee

=right('0000000000'&field,10)

Anonymous
Not applicable
Author

If it is text, try

=num(num#(field),'0000000000')

Anonymous
Not applicable
Author

@michael Solomovich Thank you . thanks for your help. And Massimo & Anjos thanks for your fast reply.

Anonymous
Not applicable
Author

i have posted another question. Can you please help me with that.

how to display rolling 13 months in the line chart

Anonymous
Not applicable
Author

i have posted another question can you please help me with that

how to display rolling 13 months in the line chart