Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kavieweg
New Contributor II

Convert Number

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

Thanks in advance

1 Solution

Accepted Solutions
sureshqv
Esteemed Contributor III

Re: Convert Number

may be this

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

4 Replies
sureshqv
Esteemed Contributor III

Re: Convert Number

may be this

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

sureshqv
Esteemed Contributor III

Re: Convert Number

try

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

LOAD Replace(value, ',', '.') as value FROM.
kavieweg
New Contributor II

Re: Convert Number

Thank you! Both works

sureshqv
Esteemed Contributor III

Re: Convert Number

nice have a nice day

Community Browser