Set Analysis Exclude Part of Modifier Set

mbeccaria — Tue, 23 Nov 2021 17:20:43 GMT

I am trying to build a set that excludes results based on part of a modifier. Here is my expression:

Count(
{
(
<[Program Enrollments.End Date] = {'No Entry'}>
*
<[Program Enrollments.Program Name] = {Outpatient,CCBHC}>
*
<[Services.Is No Show]={'No'}>
)
-
<[Services.Service Date]= {">=$(=Date(Today()-21,'YYYY-MM-DD'))"}>
}
[Services.Service Date]
)

I WANT to return clients who are in "Outpatient or CCBHC" programs, are active (thus have no Program End Date), and who have had services where they showed up (Is No Show=No)
BUT if they received a service in the past 21 days, do NOT include them.

So I want ALL users who meet the first three conditions, but REMOVE the users from that set if they have a record that meets the last condition (had a service in the past 21 days).

Can't quite figure it out. Can you help?

Re: Set Analysis Exclude Part of Modifier Set

stevejoyce — Tue, 23 Nov 2021 17:29:41 GMT

Count(
{
<
[Program Enrollments.End Date] = {'No Entry'},

[Program Enrollments.Program Name] = {'Outpatient','CCBHC'},

[Services.Is No Show]={'No'}
>
-
<[Services.Service Date]= {">=$(=Date(Today()-21,'YYYY-MM-DD'))"}>
}
[Services.Service Date]
)

topic Set Analysis Exclude Part of Modifier Set in App Development

Set Analysis Exclude Part of Modifier Set

Re: Set Analysis Exclude Part of Modifier Set