topic Re: Set Analysis and Dates in QlikView

Set Analysis and Dates

Mon, 29 Apr 2013 20:50:22 GMT

Hi,

I think this is a fairly simple question, but I'm new to QV so any help would be greatly appreciated.

The problem:

We are looking at patient data in a hospital. What we want to look at is how many of patients are receiving greater than 500 calories at their first outpatient followup from the hopsital. As such, I want to count the following:

IF Outpatient_Date is at a minimum (i.e., their first outpatient followup)

Then Count IF Caloric_Intake > 500.

We only want to be counting the caloric intake at the very first outpatient followup visit, and only want to count that caloric intake IF greater than 500 cals.

I am able to get here:

=COUNT(DISTINCT {$<[OUTPT_CALDENS] = {">=500"}>} PAT_ID)

But have no clue how to incorporate the second (and most important) parameter: that the Outpatient_Date is at a minimum.

Thank you SO much.

P.S. A second challenge:

Rather than simply counting the first outpatient follow-up, is there a way to count the MOST RECENT date from the hospital discharge date? i.e. If patient is discharged on 1-1-13 and had 20 followups, can we code into qlikview a way to match the nearest date to the hospital discharge date?

Re: Set Analysis and Dates

sushil353 — Tue, 30 Apr 2013 05:26:20 GMT

try this:

=COUNT(DISTINCT {1<[Outpatient_Date]={$(=Min([Outpatient_Date]))},[OUTPT_CALDENS] = {">=500"}>} PAT_ID)

If that dont work then post some sample data.

HTh

Sushil

Re: Set Analysis and Dates

Tue, 30 Apr 2013 17:40:05 GMT

Thanks Sushil for taking a stab at it...

so it doesn't seem to like it. I changed the field names to reflect mine and doesn't work.

here's some data:

PAT_MRN_ID DATE_OUTPT OUTPT_CALDENS

1 jan 1 300

1 jan 7 500

1 jan-27 700

2 march 17 650

2 march 29 400

2 april 5 325

2 april 7 800

3 jan 10 900

3 jan 14 1000

the correct count the above situation should be 2. There are two patients (ID 2 and 3 who receive >500 calories in their FIRST outpatient visit.

thank you SO much.

Re: Set Analysis and Dates

msteedle — Tue, 30 Apr 2013 22:39:22 GMT

There is a way to do this on the front end, but the values you request are knowable at the time of reload and will not change based on user selections. As such, it should probably be built into the data model.