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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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

1 Reply
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try this,

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

Celambarasan