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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.