I need to convert a number into a certain format text

[jusrober]

Good afternoon!

I am looking to convert a number into a certain format text.

EX. 123 Into 00123

       3345 ->  03345

Thanks in advance!

[sunny_talwar · Accepted solution]

Try like this:

=Num(123, '00000') and

=Num(3345, '00000')

In general, Num(FieldName, '00000')

[jagan]

Hi,

You can format numbers using the Num() like below

=Num(123, '00000') and

=Num(3345, '00000')

From Qlik Help file

Example:

The examples below assume the two following settings:

	Default setting 1	Default setting 2
Number format	# ##0,#	#,##0.#

num( A, '0.0' ) where A=35648.375 returns:

	Setting 1	Setting 2
String	35 648 375	35648.375
Number	35648375	35648.375

num( A, '#,##0.##', '.' , ',' ) where A=35648 returns:

	Setting 1	Setting 2
String	35,648.00	35,648.00
Number	35648	35648

num( pi( ), '0,00' ) returns:

	Setting 1	Setting 2
String	3,14	003
Number	3.141592653	3.141592653

[jusrober]

Thanks!! Wouldn't of thought to use a num function!

[jusrober]

Thanks!!

[sunny_talwar]

I am glad we were able to help. Please close this thread by marking correct and helpful responses...

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny