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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to convert Bigdecmial to Boolean and big decimal to int in tmap

Hi All,
I am having a problem converting 2 Big Decimal fields in my job.
The first one is BigDecimal to Boolean, the second is BigDecimal to Int.
Would anyone know what expressions I would use to achieve this?
Cheers
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Or alternatively - is there a function equal to SQL's ROUND() function so I could pass the boolean 1's and 0's?