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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

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
MVP
MVP

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')