Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld online is next week! REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Thousand operator / high comma in script

Hi guys

I have this script and need additionally at the last num command a high comma. Do you have ideas how to fix this issue?

if (table.Row,


round(money(Sum({<$(vSetBudget)>}budget) /-1000))))

1 Reply
Master III
Master III

First time I've ever heard anyone call a quote / apostrophe a "high comma"... had to ask Google what that was.

If you just want to add a quote at the start or end of the number, you can use a regular quote with an escape:

num(sum([Total Billing] ),'#,#0.00''') or num(sum([Total Billing] ),'''#,#0.00')

If you want to use it as the thousands or decimal separator, you could try setting it as your default Money format in your script:

SET MoneyThousandSep='''';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';

money(sum([Total Billing] ),'#''#0.00')