Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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