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

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

concatenate Bigdecimals

Hi,
I am trying to concatenate two big decimal columns and pass it onto target bigdecimal column but it gives me an error as 
The operator + is undefined type(s)java.math.BigDecimal,java.math.Bigdecimal.
At the start, I have maintained the source columns as String and handled nulls using the code below to bigdecimal but to no avail:
(StringHandling.LEN(StringHandling.TRIM(StringHandling.EREPLACE(replaceNulls.column1,"\""," ")))) == 0 ? (BigDecimal)((DecimalFormat)globalMap.get("bdfmt")).parse("0.00") : (BigDecimal)((DecimalFormat)globalMap.get("bdfmt")).parse(StringHandling.EREPLACE(replaceNulls.column1,"\"","")) .

Labels (2)
2 Replies
Anonymous
Not applicable
Author

Thank you. It worked as expected.