Set Analysis Intersection

[Anonymous]

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

Patient	FillDate	FillDateWeek
a	9/1/2016	8/29/2016
b	9/2/2016	8/29/2016
c	9/3/2016	8/29/2016
a	10/1/2016	9/26/2016
b	10/2/2016	9/26/2016

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)

[Gysbert_Wassenaar · Accepted solution]

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

[Anonymous]

Thanks! This worked perfectly.