topic Set analysis & and command in QlikView

Set analysis & and command

Fri, 10 Feb 2012 12:07:04 GMT

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

Set analysis & and command

CELAMBARASAN — Fri, 10 Feb 2012 12:12:07 GMT

Hi,

You can use like this,

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

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

Celambarasan

Set analysis & and command

stephencredmond — Fri, 10 Feb 2012 12:13:00 GMT

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

Set analysis & and command

Fri, 10 Feb 2012 12:31:45 GMT

Thanks Celambarasan and Stephen. Easier solution than I thought!