QlikView App Dev

[qlikuser222]

Hi Everyone,

I have a question on how to load a filed with alwys 6 digits?

For example below Source filed has number like

Source Field

123456

12345

123

1234

But in I want to load them as 6 digits adding 0 in the front like below

SourceFiled:

Load

123456

012345

000123

001234

Please help me understand the way to do it

Thanks

[TimvB · Accepted solution]

In the script use the following:

NUM(YourField,'000000') as LeadingZeroField

Hope it helps!