Non distinct variables

[#1]

Hi there,

I'm trying to create Quality Indicators from hospital routine data and got the following problem:

Here's a Patient who had a hysterectomy and died within her stay in Hospital. She also was diagnosed with a Tumor, so she shouldn't be included in the calculation of the Quality Indicator.

PatientNo	Diagnosis Code	Diagnosis_Indicator	Procedure_Indicator
1234567	C78.5	TUMOR	HYSTERECTOMY
1234567	C78.6	TUMOR	HYSTERECTOMY
1234567	C79.1	TUMOR	HYSTERECTOMY
1234567	C56		HYSTERECTOMY
1234567	E78.0		HYSTERECTOMY
1234567	E87.0		HYSTERECTOMY
1234567	G93.6		HYSTERECTOMY
1234567	I63.0		HYSTERECTOMY
1234567	J15.5		HYSTERECTOMY
1234567	J96.00		HYSTERECTOMY
1234567	N19		HYSTERECTOMY

My Problem is that with the following formula QV finds the 8 Diagnosis Codes that are not marked as Tumor Indicator and counts the Patient though she actually doesn't fit the definition of the Quality Indicator which exludes Tumor Patients. 

count( DISTINCT if(Procedure_Indikator = 'Hysterectomy' and Diagnosis_Indikator <> 'TUMOR' and Discharge = 'Died' , PatientNo))

Any ideas?

Thanks!

[Anonymous]

Try This

count({<Procedure_Indikator = {'Hysterectomy'} * Diagnosis_Indikator -={ 'TUMOR'} * Discharge ={ 'Died' }>}Distinct PatientNo)

[tresesco]

Try replacing the '*' with comma, like:

count({<Procedure_Indikator = {'Hysterectomy'} , Diagnosis_Indikator -={ 'TUMOR'} , Discharge ={ 'Died' }>}Distinct PatientNo)

[tunoi]

You will need something like that:

count({<Procedure_Indicator = {'Hysterectomy'} , PatientNo = E({1<Diagnosis_Indicator={"Tumor"}>})>}Distinct PatientNo)

[#5]

I guess Set Analysis is the way to go. I'm coming close with this one but still have a problem.

The formular doesn't seem to include patients that had a hysterectomy but no diagnosis to match the QI Definition --> Diagnosis_Indikator is blank.

Here is a Patient that counts correctly:

PatientNo	Diagnosis Code	Diagnosis_Indicator	Procedure_Indicator
5555555	N80.0	ICD_GIQI_Endometriose	OPS_GIQI_Hysterektomie
5555555	I10.00		OPS_GIQI_Hysterektomie
5555555	K59.0		OPS_GIQI_Hysterektomie
5555555	K66.0		OPS_GIQI_Hysterektomie

And here is one that doesn't count though it should be counted:

PatientNo	Diagnosis Code	Diagnosis_Indicator	Procedure_Indicator
7777777	D25.1		OPS_GIQI_Hysterektomie
7777777	Z11		OPS_GIQI_Hysterektomie
7777777	Z88.0		OPS_GIQI_Hysterektomie

Thank you all for the help!