topic Re: Loop until len(trim()) = x in QlikView

Loop until len(trim()) = x

Anonymous — Wed, 28 Feb 2018 15:48:00 GMT

Hello all,

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?

Thanks

Timo

jaumecf23 — Wed, 28 Feb 2018 16:43:20 GMT

try this : num(x,'0000000000')

Anonymous — Wed, 28 Feb 2018 18:06:04 GMT

Thanks for the help! Works perfectly!