Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator
Creator

Expression not working with if condition using not in ?

Please help me with the below expression

 

=If(ED_VISIT_TYPE_CD -= {'12','13'} and ED_SEPARATION_MODE_CD -= {'99'},1,0)

Labels (1)
1 Reply
sidhiq91
Specialist
Specialist

@ashmitp869  You are using the Set analysis syntax in the If statement. You can write it as below as

if( not match (ED_VISIT_TYPE_CD,'12','13')  and not match(ED_SEPARATION_MODE_CD ,'99'),'1','0') as New_Column

This should resolve your issue.