Won't format money! '#,###.'

[Breezy]

I am making a table:

1. Column 1 is State. 

2. Column 2 through 10 are data that correspond with each state. 

I loaded my Excel file into Qlik and none of the money format transferred to Qlik from Excel! Now instead of $47,000,000 it shows as 47000000

I fixed another table by going through each measure and that worked very well. However, this table is way bigger so I would like to fix this in the Data Load Editor so I do not have to go into each and every column. I tested with both VizLib table and the regular table. and cannot figure it out. 

LOAD
Animal
Money#("FY 19 Frog Grant",'#,###.') as "FY 19 Frog Grant", 

[Lakshminarayanan_J]

@Breezy 

Please find the below screenshot for your reference ,

Without Money Format:

With Money Format:

[justISO]

Hi, first, try your expression without #, Money("FY 19...

If this not solve your problem, check what format is set in you Data Load Editor 'Main' section near MoneyFormat. Is it: SET MoneyFormat='$#,##0.00;-$#,##0.00';

If yes, than I believe expression

Money("FY 19 Frog Grant") as "FY 19 Frog Grant"

should work without problem.

[Breezy]

Thanks for the screenshots. That is very helpful! What is the difference between that and the "Num" function, which I think also gives similar results. 

[Lakshminarayanan_J]

@Breezy 

It seems there is no  difference  between both the function which can be used interchangeably.

NUM Syntax:

Num(number[, format[, dec_sep [, thou_sep]]])

Return data type: dual

MONEY Syntax:

Money(number[, format[, dec_sep[, thou_sep]]])

Return data type: dual