Set analysis & and command

[#1]

Hello/Hola/Namaste/Dia Dhuit,

I wish to have a set analysis expression which has the and command where the field admission is between the two variables. After some searching, I have come up with the following but with no success. The results appear to not be filtered by the first variable.

Count({< caretype={'N'},admission = {">=$(=date((vMondayofLastWeek)))"} > + < admission = {"<=$(=date((vSundayofLastWeek)))"},  referredby = {'101021889','101030294'}  >} distinct rescare_Id)     

Any ideas?

Dank u,

Matt

[CELAMBARASAN · Accepted solution]

Hi,

     You can use like this,

Count({< caretype={'N'},admission = {">=$(=date((vMondayofLastWeek)))<=$(=date((vSundayofLastWeek)))"},  referredby = {'101021889','101030294'}  >} distinct rescare_Id)

Or

Count({< caretype={'N'},admission = {"admission >=$(=date((vMondayofLastWeek))) And admission <=$(=date((vSundayofLastWeek)))"},  referredby = {'101021889','101030294'}  >} distinct rescare_Id)

Celambarasan

[stephencredmond]

Hi,

Combine the two expressions in one set.  I haven't syntax checked this but it would look like this:

Count({< caretype={'N'}, admission = {">=$(=date((vMondayofLastWeek)))<=$(=date((vSundayofLastWeek)))"},  referredby = {'101021889','101030294'}  >} distinct rescare_Id)

Regards,

Stephen

[#4]

Thanks Celambarasan and Stephen. Easier solution than I thought!