Discussion Board for collaboration related to QlikView App Development.
I have a number in following format: 99265, 13, 123468
I want to load it as a 10 digit string with zero in front. --> 0000099265, 0000000013, 0000123468
My first try would be something like this:
if(len(trim(x))=1; '00000000' & x ;if(len(trim(x))=2; '0000000' & x ;.....
Is there a way to do this smoother than this?
try this : num(x,'0000000000')
View solution in original post
Thanks for the help! Works perfectly!