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: 
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