Count with OR function

afitzgerald — Mon, 30 Aug 2021 20:40:36 GMT

I am new to using Qlik Sense and I am running into an error with a KPI function I am creating. I am trying to count the total number of distinct patients in a program. Throughout the patients' time in a facility, they can be in a variety of the programs, but I want a count of unique patients of these three programs combined. When I use the code below, it will only give me the count for Adult Care 3. If I move Adult Care 1 to the end of the expression, it only gives the count of Adult Care 1. Any suggestions? There are a ton of service programs but I am focusing on these 3 specifically, which is why I can't just do a basic distinct count.

=Count({$<Service.Program={'Adult Care 1'}, [Service.Program]={'Adult Care 2'}, Service.Program={'Adult Care 3'} >} distinct ID)

Re: Count with OR function

stevejoyce — Mon, 30 Aug 2021 20:41:45 GMT

=Count({$<Service.Program={'Adult Care 1','Adult Care 2','Adult Care 3'} >} distinct ID)

topic Count with OR function in App Development

Count with OR function

Re: Count with OR function