https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315995#M86588 Hi, <BR />I don't know what you exactly want to do, but you can also write like below... <BR />row1.amount != BigDecimal.valueOf(0) <BR />So, if you use it in expression builder, you probably would like to make a logical comprasion. for that; <BR />row1.amount != BigDecimal.valueOf(0) ? do x : do y Sat, 11 Feb 2012 19:58:43 GMT Anonymous 2012-02-11T19:58:43Z https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315992#M86585 Hello, <BR />Please teach me! <BR />What i wanna do is following. <BR />When creating comparison sentence in Expression Builder <BR />for compare both values. <BR />Then this error has occur and displayed massage like <BR />it is different type of value that Bigdecimal and Integer. <BR />comparison sentence i wrote is following. <BR /> /row1.amount != 0 <BR />row1.amount is Bigdecimal. <BR />How can I compare these values? <BR />Thanks! <BR />Regards, Sat, 16 Nov 2024 12:23:40 GMT https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315992#M86585 Anonymous 2024-11-16T12:23:40Z https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315993#M86586 tak a look at java documentation. Thu, 09 Feb 2012 09:44:04 GMT https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315993#M86586 Anonymous 2012-02-09T09:44:04Z https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315994#M86587 Hi, <BR />row1.amount!=new BigDecimal(0). But you should the syntaxe row1.amount.compareTo(new BigDecimal(0))? new BigDecimal(0) (it s equal) : (not equal) Thu, 09 Feb 2012 10:07:12 GMT https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315994#M86587 Anonymous 2012-02-09T10:07:12Z https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315995#M86588 Hi, <BR />I don't know what you exactly want to do, but you can also write like below... <BR />row1.amount != BigDecimal.valueOf(0) <BR />So, if you use it in expression builder, you probably would like to make a logical comprasion. for that; <BR />row1.amount != BigDecimal.valueOf(0) ? do x : do y Sat, 11 Feb 2012 19:58:43 GMT https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315995#M86588 Anonymous 2012-02-11T19:58:43Z https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315996#M86589 First convert BigDecimal tparam to integer in Expression Builder. <BR />For Example : row1.ID.intValue() &gt;= 2? "Y" : "N"; Thu, 29 Sep 2016 11:51:14 GMT https://community.qlik.com/t5/Talend-Studio/How-to-compare-value-of-BigDecimal-with-a-integer-in-tMap/m-p/2315996#M86589 _AnonymousUser 2016-09-29T11:51:14Z