topic MoneyFormat in QlikView

MoneyFormat

Thu, 02 Sep 2010 09:21:36 GMT

Hi,

Please i want to know how to apply MoneyFormat to a field of LOAD statement?

Thanks for your help.

MoneyFormat

Thu, 02 Sep 2010 09:36:30 GMT

I didn't get your question right! Could you please explain briefly! So that we can help you out...

MoneyFormat

Miguel_Angel_Baeyens — Thu, 02 Sep 2010 09:40:28 GMT

Hello Yimen,

Try with

Money(CurrencyField) AS Field

That will return the number value stored in CurrencyField following the format stored in your MoneyFormat at the beginning of your script.

Regards.

MoneyFormat

sunil2288 — Thu, 02 Sep 2010 10:26:21 GMT

HI Yiemn,

You can change the format in the edit script main page Which is by default

'SET MoneyFormat='$#,##0.00;($#,##0.00)';' you can change it as you want and can load the data in the format you want.

Regards

Sunil

MoneyFormat

sunil2288 — Thu, 02 Sep 2010 10:29:15 GMT

HI Yiemn,

Rather if you want to change the MoneyFormat for a single field you can Use the MoneyFormat( ) Function avaliable in the Foramttin Function Catagory in the edit script.

Regards

Sunil