topic 'or' selector in set analysis in QlikView

'or' selector in set analysis

cbv — Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to create a set analysis to look at patients that meet at least one of 2 criteria: Acuity = 1 or Disposition = PICU. I would like it to sum the patients seen that meet either 1 or both of those criteria.

I have the below set analysis but know it's looking for patients that meet both - how do I adjust this so that it does an OR not an AND?Is there something other than a set analysis I should use?

count({<
[Acuity]={1},
[Disposition]={'PICU'}>}
[Patient Seen])

Re: 'or' selector in set analysis

Taoufiq_Zarra — Thu, 15 Oct 2020 15:40:29 GMT

@cbv like ?

count({<[Acuity]={1}>+<[Disposition]={'PICU'}>} [Patient Seen])

Re: 'or' selector in set analysis

cbv — Thu, 15 Oct 2020 17:32:30 GMT

perfect, thanks so much!

Re: 'or' selector in set analysis

cbv — Thu, 15 Oct 2020 17:47:30 GMT

As a follow-up, is there a way to create a selector for this without editing the script (I don't' have access). So I could ideally select this and it would add a condition to the current selections to pull any patient with an acuity of 1 or disposition of PICU? Trying to build out a table to show patient level detail of anyone meeting these criteria.