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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
rp2018
Creator
Creator

Error while assign values to null in tmap

I'm creating 2 variables in tmap and need to assign value to a null.

 

Source:

 

Deleted column is boolean type

SVamount column is BigDecimal type

 

Vars are created using this:

row10.Deleted==null?1:row10.Deleted 

row10.SVamount==null?new BigDecimal(0):row10.SVamount

 

When I take these two vars on the output filter, it errors out with.

Type mismatch:  cannot convert from ObjectComparable<?>Serializable to boolean.

 

 

 

Labels (2)
1 Solution

Accepted Solutions
manodwhb
Champion II
Champion II

@rp2018,you need to use below way for vars.since 1 will not able to convert to Boolean.

Vars are created using this:

row10.Deleted==null?true:row10.Deleted 

row10.SVamount==null?new BigDecimal(0):row10.SVamount

View solution in original post

1 Reply
manodwhb
Champion II
Champion II

@rp2018,you need to use below way for vars.since 1 will not able to convert to Boolean.

Vars are created using this:

row10.Deleted==null?true:row10.Deleted 

row10.SVamount==null?new BigDecimal(0):row10.SVamount