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

conversion of integer to bollean

team,

 

How to convert of integer to boolean.

 

integer values: 1,0, 23, etc

if col1>0 set 1 else 0.

 

target column is boolean.

 

thanks in advance

 

Thanks

shree

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

 

    Please use a tmap with expression (row1.col1 > 0)?true:false  where col1 is the input column name.

0683p000009Lz0E.png

 

 

 

Please mark the topic as solution provided if the reply has helped you. Kudos are also welcome 🙂

 

Warm Regards,

 

Nikhil Thampi

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi,

 

    Please use a tmap with expression (row1.col1 > 0)?true:false  where col1 is the input column name.

0683p000009Lz0E.png

 

 

 

Please mark the topic as solution provided if the reply has helped you. Kudos are also welcome 🙂

 

Warm Regards,

 

Nikhil Thampi

Anonymous
Not applicable
Author

Thanks @nthampi,

 

Small query without if condition how to convert integer to Boolean,

 

Thanks

shree