Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stephanr
New Contributor

High commas as thousands separator in text object

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

1 Solution

Accepted Solutions
Not applicable

Re: High commas as thousands separator in text object

Try this:

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

3 Replies
Not applicable

Re: High commas as thousands separator in text object

Try this:

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

stephanr
New Contributor

Re: High commas as thousands separator in text object

You're a genious!

Thanks for the hint!

stephanr
New Contributor

Re: High commas as thousands separator in text object

It even works with

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

Community Browser