How to append leading zero in front of number and make it in 10 digit in qlikview ?

[#1]

Hi All,

I am new to qlikview.

I have a questions - how can we append leading zero in front of numbers and make it in 10 digit ?

Example :

We have : 12345

how can we make it - 0000012345 ?

Appreciate your help.

[swuehl]

Use the num() function with an appropriate format code:

=num( 12345, '0000000000')