Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

Thousand separator - high comma

Hi experts

I have the following formula for low comma as thousand separator:  num(round(money(Sum({<$(vSetBudget)>}budget) /-1000)), '#,###.','.',',')

But I need a high comma - any ideas?

Regards, Thomas

Labels (1)
1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

You can create an escape sequence for the single quote by typing it twice:

num(budget, '#''###.','.','''')

See https://community.qlik.com/t5/Qlik-Design-Blog/Escape-sequences/ba-p/1469770

Also, the Money() function is redundant: It is a formatting function that is overridden by the Num() function.

View solution in original post

1 Reply
hic
Former Employee
Former Employee

You can create an escape sequence for the single quote by typing it twice:

num(budget, '#''###.','.','''')

See https://community.qlik.com/t5/Qlik-Design-Blog/Escape-sequences/ba-p/1469770

Also, the Money() function is redundant: It is a formatting function that is overridden by the Num() function.