Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I convert a string field to numeric ? [ ex .- "$0.01M" to "0.01"]

I have a Payment field having values like "$0.01M" . I want it in numeric form "0.01". What is the best way to do that ?

Thnks .

7 Replies
Anonymous
Not applicable
Author

you can use substring()

arulsettu
Master III
Master III

if you want only numeric values try this

KeepChar('$0.01M','.0123456789')

Anonymous
Not applicable
Author

try:

=mid(FieldName,2,len(FieldName)-1) as NewField

settu_periasamy
Master III
Master III

Hi,

May be try this..

=Num(Num#('$0.01M','$#.##M'),'#.##')

Anonymous
Not applicable
Author

it will skip: $ sign as we are picking from 2 position

will skip M symbol as well as we are fetching till len(Field)-1

Kushal_Chawda

try

TextBetween(Payment field,'$','M') as Number

himanshi
Contributor III
Contributor III

hiii,

you can also try numbers tab in chart properties.here you have options,you can choose the format as you want.

Regards,

Himanshi Dubey