topic Re: Non distinct variables in QlikView

Non distinct variables

Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Non distinct variables

Anonymous — Wed, 18 Jan 2017 08:10:42 GMT

Try This

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

Re: Non distinct variables

tresB — Wed, 18 Jan 2017 08:49:05 GMT

Try replacing the '*' with comma, like:

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

Re: Non distinct variables

tunoi — Wed, 18 Jan 2017 09:33:43 GMT

You will need something like that:

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

Re: Non distinct variables

Wed, 18 Jan 2017 11:12:09 GMT

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!