Qlik Community

Qlik Sense on AWS & Azure

Discussion board where members can learn more about Qlik Sense deployments on Public Cloud Infrastructures such as AWS and Azure.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jusrober
New Contributor II

I need to convert a number into a certain format text

Good afternoon!

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

EX. 123 Into 00123

       3345 ->  03345

Thanks in advance!

1 Solution

Accepted Solutions

Re: I need to convert a number into a certain format text

Try like this:

=Num(123, '00000') and

=Num(3345, '00000')

In general, Num(FieldName, '00000')

Capture.PNG

5 Replies

Re: I need to convert a number into a certain format text

Try like this:

=Num(123, '00000') and

=Num(3345, '00000')

In general, Num(FieldName, '00000')

Capture.PNG

MVP & Luminary
MVP & Luminary

Re: I need to convert a number into a certain format text

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
New Contributor II

Re: I need to convert a number into a certain format text

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

jusrober
New Contributor II

Re: I need to convert a number into a certain format text

Thanks!!

Re: I need to convert a number into a certain format text

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