Match and NotMatch not working correctly

[ashmitp869]

HI there,

Please kindly assist with the match and not match function in qlikview script -

IF([ENCOUNTER_TYPE] = 'Inpatient' AND [episode_of_care_type]= '09', 'Others',IF([ENCOUNTER_TYPE] = 'Non-Admitted', 'Non Admitted',
IF([ENCOUNTER_TYPE] = 'Emergency', 'Emergency',
IF(Match([episode_of_care_type], '1','01' ,'5' ,'05'), 'Acute',
IF(Not Match([episode_of_care_type],'1' ,'01','5','05' ,'M','9','09'), 'Sub-Acute','Unknown' ))))) AS [Episode of Care Type Groups]

I am not getting the 'Acute; and 'Sub-Acute' group.

Please kindly assist.

Thanks

[lironbaram]

You are using two different fields in your expression, so if one of the first two conditions is fulfilled, the latter two wouldn't be relevant.
Maybe you need to create two separate fields.