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: 
Bharath12
Contributor III
Contributor III

convert boolean values

Hi All,

 

Can some one help me with boolean conversions for below mentioned source values 

 

Source values                

True

Flase

Null

Empty string

 

i would like to get the output if the value is 'true' as '1' and for the remaining as '0'

 

Thanks,

 

 

Labels (5)
1 Reply
TRF
Champion II
Champion II

Try this expression
"true".equals(row1.yourField) ? 1 : 0