.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.
Best Answer
-
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
1
Altair EmployeeAnswers
-
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
1 -
That's exactly what I needed. Thank you!
0