Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Conversion??

Hi All,

I have a excel file where I am pulling numbers.The number format are R$ 222.00, R$ 222.998 etc

I am unable to do sum, but I can do count.

How to format the column in the backend so I can actually do the sum.

Thanks

1 Solution

Accepted Solutions
sunny_talwar

Try this

LOAD

Money#(Amount,'R$ #.###,###', ',', '.') as Amount

FROM

[Test.xls]

(biff, embedded labels, table is Sheet1$);

View solution in original post

7 Replies
sunny_talwar

May be this

Money#(FieldName, 'R$ #,###.###') as FieldName

Frank_Hartmann
Master II
Master II

or maybe this:

num#(mid(YourField,3)) as number

qlikuser222
Creator
Creator
Author

Hi ,

Thanks for reply.

I tried it but still not working .

PFA

Thanks

sunny_talwar

I don't see anything attached... but seems to be working for me

Capture.PNG

I see attached now

sunny_talwar

Try this

LOAD

Money#(Amount,'R$ #.###,###', ',', '.') as Amount

FROM

[Test.xls]

(biff, embedded labels, table is Sheet1$);

sunny_talwar

Or try this

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='R$#,##0.00;(R$#,##0.00)';

LOAD Amount

FROM

[Test.xls]

(biff, embedded labels, table is Sheet1$);

qlikuser222
Creator
Creator
Author

Thanks