topic Re: I need to convert a number into a certain format text in Management & Governance

I need to convert a number into a certain format text

jusrober — Fri, 02 Apr 2021 07:38:28 GMT

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 — Mon, 09 Jan 2017 02:17:07 GMT

Try like this:

=Num(123, '00000') and

=Num(3345, '00000')

In general, Num(FieldName, '00000')

jagan — Mon, 09 Jan 2017 05:43:30 GMT

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:

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

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

jusrober — Mon, 09 Jan 2017 12:27:36 GMT

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

jusrober — Mon, 09 Jan 2017 12:28:16 GMT

Thanks!!

sunny_talwar — Mon, 09 Jan 2017 12:31:06 GMT

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

Best,

Sunny