How to represent Number format Money

HI,

If you are not using straight table, use format symbols.

For straight table you need to change the expression to include formating. Num(<expression>/1000,'$ #,##0.00 K')

Kiran.

might be a bit late

but maybe also helpful:

SET vSize = Div(Log10($1),3);
SET vFormatNumber = Dual(Num($1/Pow(10,3*$(vSize($1))),'#,##0')&' '&Pick($(vSize($1)),'K','Mil','Bil','Tril'),$1);

LOAD *,
     $(vFormatNumber(parameter)) as paramFormat;
LOAD pow(10,Rand()*14) as parameter
AutoGenerate 30;

regards

Marco

Hi,

You can change the auto number formatting symbol from "G" to "B" in javascript

Please check this Steps to Change : Qlik Sense - Billions number format 'G' to 'B'

Thanks,

Lakshmikandh

Hi team,

Anyone got solution for this, I am facing similar issue.

Money format is working fine in bar chart but not in pie chart. i am using QV11SR9.

Regards,

Sai