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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kavieweg
Partner - Creator
Partner - Creator

Convert Number

How can i convert a Number: 51,78944 to 51.78944 ?

Thanks in advance

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

may be this

=Replace(Value,',','.')

View solution in original post

4 Replies
Chanty4u
MVP
MVP

may be this

=Replace(Value,',','.')

Chanty4u
MVP
MVP

try

SET DecimalSep='.'; // . instead of ,

LOAD Replace(value, ',', '.') as value FROM.
kavieweg
Partner - Creator
Partner - Creator
Author

Thank you! Both works

Chanty4u
MVP
MVP

nice have a nice day