Qlik Sense Num format with thousand separator and decimal places

[PhilipMertin]

I'd like to know why you can't format a number with a thousand separator and decimal places in Qlik Sense, but you can in Qlikview. I find this so strange and frustrating..

i.e. num(sum($(vOnhand2)),if(vDisplay='QTY PRIMARY UNIT','# ##0','# ##0.000'))

The latter returns a number that looks like this on the front end: "123456 ##0.000"

[tresesco]

It could be because one supposed to be space character in your format is not really being read as space but something else. Try to remove that from format, and then press space bar in expression itself. 

[PhilipMertin]

Hi.. I've done that and it makes no difference unfortunately. I use a normal space.

[tresesco]

Space is causing the issue it seems. You can try a work around like:

Replace(Num(1234.5,'#,##0.000'), ',', ' ')

[PhilipMertin]

Makes no difference.. My expression now looks like this:

num(sum($(vOnhand2)),if('$(vDisplay)'='QTY PRIMARY UNIT','# ##0',
replace('#,##0.000',',',' ')
))

Makes sense that it won't make a difference, as a space didn't work in the first place. Now we're trying to replace a comma with the space that didn't work in the first place.

I doubt it's got anything to do with the space.. I think Qlik Sense has a shortfall here and it's really bad. Doesn't seem to be able to handle formatting using an expression like this.

[tresesco]

Replace() has to be outside num().

[PhilipMertin]

Still doesn't work. Now the thousand separator disappears from the number..