Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Convert object (money) datatype to double

What is the best way to convert an object "money" to double?

 

The current structure of the object is (ie. 2,709.00) where double doesn't accept the "comma" value. I tried using the tConvertType (to convert object to double) but I am not sure how to parse the "comma" from there. I also tried parsing it from tMap and it's not working as it's looking for a "string" and not a double.

 

Labels (3)
1 Reply
Anonymous
Not applicable
Author

You may be able to try the following way at tMap:

Double.parseDouble((String.valueOf(row8.money)).replace(",", "")) 

I hope it'll help you.