Discussion Board for collaboration on QlikView Scripting.
If I have item numbers, that come in in various lengths, say, 3 to 5 characters, but I want to make them all 6 characters long, how do I do that? I've looked everywhere but can't find any topics pertaining specifically to this, thanks for your help.
Go to Solution.
Try it with num(Field, '000000')
If your field name is for example myField then:
=Repeat('0',6-Len(myField )) & myField
let me know
yes Marcus is correct you will get your numbers followed by 0 (zeros)
ex for 10 you will get 000010
Perfect! Worked! Thank you!
That solution works only with numbers ...