Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Help me changing a string to a number

Hello Guys,

i have a field that i imported called A which is a string and written like that 3,5689548.

i need to convert it to a number & to replace the comma with a dot.

so can anyone help plz

Labels (1)
1 Reply
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try this,

     Num(Num#(FieldName,'###,##',','),'###.##','.')

Celambarasan