Set Analysis Intersection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a fairly complex data set that I have simplified into the table below.

I want to count the patients that had a fill in the first action week and had a fill in the remainder of the data.

In the example above, i would want the result to be 2.

count({<FillDateWeek = {'$(vMinFillWeek)'}>*<FillDateWeek -= {'$(vMinFillWeek)'}>}distinct Patient)

Where vMinFillWeek = min(FillDateWeek)

Re: Set Analysis Intersection

Gysbert_Wassenaar — Mon, 31 Oct 2016 16:53:43 GMT

Try this: count({<FillDateWeek = {'$(vMinFillWeek)'}, Patient={"=count(distinct FillDate)>1"}>}distinct Patient)

Anonymous — Mon, 31 Oct 2016 17:46:45 GMT

Thanks! This worked perfectly.