Qlik Community

New to Qlik Sense

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

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
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,
num(
(
Sum({<$(vSetBudget)>}budget)
)
/

top(Sum({<$(vSetBudget)>}budget)) 
,'0.00%')


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

1 Reply
Or
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')