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

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