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: 
Tatynout
Contributor III
Contributor III

Modification of the decimal character

Hello,

I am new to Qlik Sense. I would like to change the decimal separator  of a field containing numbers from " . " to " , " .

Can someone please help?

1 Solution

Accepted Solutions
charlie_firemind
Partner - Contributor III
Partner - Contributor III

Hey, 

Depends if these settings are being auto applied from set defaults:

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';

or if the value is coming from the data in which you can update using the Replace function.

Replace(text, from_str, to_str)

so..

Replace([Field Name], '.', ',')

C

View solution in original post

1 Reply
charlie_firemind
Partner - Contributor III
Partner - Contributor III

Hey, 

Depends if these settings are being auto applied from set defaults:

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';

or if the value is coming from the data in which you can update using the Replace function.

Replace(text, from_str, to_str)

so..

Replace([Field Name], '.', ',')

C