Match and NotMatch not working correctly

ashmitp869 — Fri, 27 Aug 2021 01:32:30 GMT

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

Re: Match and NotMatch not working correctly

lironbaram — Fri, 27 Aug 2021 05:42:38 GMT

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.

topic Match and NotMatch not working correctly in QlikView

Match and NotMatch not working correctly

Re: Match and NotMatch not working correctly