Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

How to convert from string to currency, and change the decimal and thousand separator

Dears,

I have a CSV file with the following content on column [Value]: "19197489,152"

How can I show the column [Value] with following currency format: R$ 19.197.489.152,00 ?

 

I'm from Brazil and my 

 

Thanks a lot

Bruno Lelli

1 Solution

Accepted Solutions
saran7de
Master
Master

Please try this.

=Money('19197489,152','$#.##0,00',',','.')

View solution in original post

3 Replies
saran7de
Master
Master

Please try this.

=Money('19197489,152','$#.##0,00',',','.')

View solution in original post

brunolelli87
Creator II
Creator II
Author

Hello,

Thanks for your quick response, but it's showing 0 as result...

 

Please, check some configurations and the result I'm getting:

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';

num([Ativo Total], 'R$ #.##0,00;-R$ #.##0,00', ',', '.') as [Ativo Total],

Result: R$ 19197489.000,00

-------------------

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';

Money([Ativo Total],'$#.##0,00',',','.') as [Ativo Total],

Result: R$ 19197489.000,00

saran7de
Master
Master

Please tell me, how the data in [Ativo Total] looks like. I still see this is working for me.