Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.