Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.