Num() Formating

[KD_]

Hello Qlik world. I am trying to understand what the purpose of dec_sep & the thou_sep is in the function syntax: Num(number[, format[, dec_sep [, thou_sep]]]). I have looked everywhere and cannot find where it is clearly explained. Thanks in advance.

[Vegar]

Let me try to explain using an example. (Image is from QlikView, but Qlik Sense handle this in the same manner). If you need other separators than the default ones defined by variables ThousandSep and DecimalSep in the script then you need to set these explicit in the num() expression.

Please review image below where I've used num(Num, '# ##0,0') when format is using the default separators, but if I need other separators I need to define them as in the expression to the right num(Num, '#|||##0:::0', ':::', '|||') where I want to use ':::' as decimal separator and '|||' as thousand separator.  

[KD_ · Accepted solution]

Thank you, I get it now.