topic Re: Conditional Count in App Development

Conditional Count

yreboredo — Thu, 21 Jun 2018 22:19:07 GMT

Hello,

We need to create a measure to get the distinct count of patients when any of the fields listed below are equal to 'Yes'. The expression below is counting patients regardless of the field value.

Count(

{<[10467]={'Yes'}>

//or

+<[20229]={'Yes'}>

//or

+<[23385]={'Yes'}>

//or

+<[22927]={'Yes'}>

//or

+<[20940]={'Yes'}>

//or

+<[23209]={'Yes'}>

//or

+<[23495]={'Yes'}>

//or

+<[23555]={'Yes'}>

//or

+<[23576]={'Yes'}>} Distinct PAT_ID)

Any help will be appreciated.

Thanks

Re: Conditional Count

Lisa_P — Fri, 22 Jun 2018 03:29:07 GMT

Just use ',' as a separator for each field in Set Analysis.

Count( {<[10467]={'Yes'}, [20229]={'Yes'}, [23385]={'Yes'}, [22927]={'Yes'}, [20940]={'Yes'}, [23209]={'Yes'}, [23495]={'Yes'}[23555]={'Yes'}, [23576]={'Yes'}>} Distinct PAT_ID)

Re: Conditional Count

sunny_talwar — Fri, 22 Jun 2018 11:32:00 GMT

How about this

Count(DISTINCT {<PAT_ID = {"=SubStringCount('|'&[10467]&'|'&[20229]&'|'&[23385]&'|'&[22927]&'|'&[20940]&'|'&[23209]&'|'&[23495]&'|'&[23555]&'|'&[23576]&'|', '|Yes|') > 0"}>} PAT_ID)

Re: Conditional Count

yreboredo — Fri, 22 Jun 2018 11:53:52 GMT

It worked...Thank you!

Re: Conditional Count

yreboredo — Fri, 22 Jun 2018 12:00:28 GMT

Hi Lisa,

Your suggestion will work if all the fields meet the condition (and), in our case we need any of the fields (or).

Thank you for looking into it!