topic Re: How to convert the value '1' into the format '000001' ? in QlikView

How to convert the value '1' into the format '000001' ?

cheburashka — Wed, 20 Nov 2013 14:14:19 GMT

Hello,

I want to create a new field "A" with the values '2012000001, 2012000002,..., 2012000011,'.

These values are created from the values of the fields "number" = '1,2,3,4,...' and "year" = 2012,2013,2014.

How do I create the field A in the script?

How to convert the value '1' to '000001' ?

, Thanks for your input, Koen

swuehl — Wed, 20 Nov 2013 14:16:34 GMT

=num(1,'000000')

or in your script

LOAD

year,

number,

num#(year & num(number, '000000')) as A,

...

MayilVahanan — Wed, 20 Nov 2013 14:17:58 GMT

Try like this

=Num(1,'000000')