Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

.And. .Or. Operators in Filters

I am trying to use multiple .and. operators with an .or. in a filter and it doesn't seem to want to work.

Here is my example. However, it will not accept this. I have tried with parenthesis in a couple different spots as well. I feel like I need parenthesis somewhere. I am just not sure where to put them in monarch. Worst case I can just do two different filters. However, I would rather just do in one if possible.

It doesn't seem to give me trouble until I ad the extra ".and.

Journal .In.("CHG ITS","CHG EMR")  .And. [ProviderCategory] .NotIn. ("Hospitalist","Emergency Medicine","Anesthesiology")  .Or.  Journal .In.("CHG ITS","CHG EMR")  .And. [NPI] = ""

Any help is appreciated.

Find more posts tagged with

English

Monarch

v2020.0

Accepted answers

Baba_Majekodunmi_703

Hi Vaughn,

I would recommend using a 'Compound' filter. So create your filters individually, and then create a compound filter to combine them. Here's a link to a video on filters in the community;

Monarch Classic Essentials: Training 3 of 10: Filters

https://community.altair.com/community?id=kb_article_view&sysparm_article=KB0116808

All comments

Baba_Majekodunmi_703

Hi Vaughn,

I would recommend using a 'Compound' filter. So create your filters individually, and then create a compound filter to combine them. Here's a link to a video on filters in the community;

Monarch Classic Essentials: Training 3 of 10: Filters

https://community.altair.com/community?id=kb_article_view&sysparm_article=KB0116808

Vaughn

That's exactly what I needed. Thank you!