topic Re: High commas as thousands separator in text object in QlikView

High commas as thousands separator in text object

stephanr — Mon, 09 Dec 2013 15:30:53 GMT

Hi everyone

I try to format a number with the "num()"-function in a text object and I want to have high commas as thousands separator (e.g. 34'342'045). The problem is, that high commas are interpretet as "string end", so it doesn't work... Any ideas?

I Tried num(123456,'#'##0','.',''') with no effect

When I take num(123456,'#,##0','.',',') it shows 123,456 in the text object as expected

Thanks in advance,

Stephan

Re: High commas as thousands separator in text object

Mon, 09 Dec 2013 15:43:39 GMT

Try this:

Replace(Num(35000,'###,###.'),',',Chr(39))

Re: High commas as thousands separator in text object

stephanr — Mon, 09 Dec 2013 15:50:24 GMT

You're a genious!

Thanks for the hint!

Re: High commas as thousands separator in text object

stephanr — Mon, 09 Dec 2013 16:15:40 GMT

It even works with

num((123456),'#'&Chr(39)&'##0','.',Chr(39))