Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Always load 6 digits?

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

Labels (1)
1 Solution

Accepted Solutions
TimvB
Creator II
Creator II

In the script use the following:

NUM(YourField,'000000') as LeadingZeroField

Hope it helps!

View solution in original post

1 Reply
TimvB
Creator II
Creator II

In the script use the following:

NUM(YourField,'000000') as LeadingZeroField

Hope it helps!

View solution in original post