Matrix problem

Sat, 14 Sep 2013 19:47:21 GMT

I’ve got a dataset which contains a list of patients some of whom may have admissions for Asthma, Diabetes, Epilepsy, etc.

I’m trying to create a matrix or grid to show total patients not simply for each of these conditions but a total where there may have been an admission for more than one condition. So for example in the table below, 5 patients have had admissions for Asthma only but 1 patient has
had an Asthma admission and also a previous admission for Diabetes.

Asthma Diabetes Epilepsy

Asthma 5 1

Diabetes 2

Epilepsy 1

Can this also be displayed as a bubble chart?

Thanks for your help

Re: Matrix problem

CELAMBARASAN — Sat, 14 Sep 2013 21:54:02 GMT

Hi,

You can do it by creating another link field for the conditions.

Data:

LOAD * INLINE [

Patient, Condition, Visit

1, Asthma, 1

2, Diabetes, 1

3, Asthma, 1

1, Epilepsy, 1

5, Asthma, 1

1, Diabetes, 1

];

DataMatrix:

LOAD

Patient,

Condition AS ConditionMatrix

Resident Data;

You will get an idea on checking the attached file

topic Matrix problem in QlikView

Matrix problem

Re: Matrix problem