Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

cheburashka
Contributor III

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

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

1 Solution

Accepted Solutions
MVP
MVP

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

=num(1,'000000')

or in your script

LOAD

     year,

     number,

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

     ...

2 Replies
MVP
MVP

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

=num(1,'000000')

or in your script

LOAD

     year,

     number,

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

     ...

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

Hi

Try like this

=Num(1,'000000')

Community Browser