Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stephanr
Contributor
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

Try this:

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

View solution in original post

3 Replies
Not applicable

Try this:

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

stephanr
Contributor
Contributor
Author

You're a genious!

Thanks for the hint!

stephanr
Contributor
Contributor
Author

It even works with

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