Issue with space thousands separator in Qlik Cloud (# ##0 formatting)

[herard_bertrand]

Hello,

Could someone help me understand an issue I'm having with number formatting?

I want to format numbers using a space as a thousands separator. This works fine in QlikView and works sometimes in Qlik Cloud, but it is inconsistent. When using the standard format # ##0, I occasionally get strange displays like 0 ##0 or 1e+6 ##0 in the chart ??.

Has anyone encountered this issue or found a reliable way to enforce a space thousands separator in Qlik Cloud?

Thanks in advance!

[MatheusC · Accepted solution]

Try this:

Replace(Num(your_measure, '#,##0'), ',', ' ')

or

Num(Num#(your_measure, 'your_format'), '# ##0', '.', ' ')