Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon!
I am looking to convert a number into a certain format text.
EX. 123 Into 00123
3345 -> 03345
Thanks in advance!
Try like this:
=Num(123, '00000') and
=Num(3345, '00000')
In general, Num(FieldName, '00000')
Try like this:
=Num(123, '00000') and
=Num(3345, '00000')
In general, Num(FieldName, '00000')
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 |
Thanks!! Wouldn't of thought to use a num function!
Thanks!!
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