topic Re: Building a Report Filter using OR instead of AND in Reporting Service & Alerting

Building a Report Filter using OR instead of AND

JfrankGroundSystems — Thu, 12 Mar 2026 16:45:43 GMT

We are using Qlik cloud and I am trying to setup a report filter for a recipient. Essentially I need to do Opportunity.SalesRep = 'Aspire Admin' OR Property.AccountOwner = 'Aspire Admin'. I have tried using the Override flag on both the filters but it appears that whatever I try it is essentially doing an AND instead of an OR between the two filters. Is there a way to accomplish this?

Re: Building a Report Filter using OR instead of AND

WeLoveQlik — Thu, 12 Mar 2026 19:31:52 GMT

Hello!

try this Set analysis

{<Opportunity.SalesRep = {'Aspire Admin'}>+<Property.AccountOwner = {'Aspire Admin'}>}

Re: Building a Report Filter using OR instead of AND

Lech_Miszkiewicz — Fri, 13 Mar 2026 02:56:58 GMT

Hi @JfrankGroundSystems

I have written comprehensive article about how to deal with it.

https://nprintingadventures.com/2021/09/23/filters-in-nprinting-how-hard-can-it-be-part-2-or-mode/

I know this is based on NPrinting example, but principles are exactly the same.

cheers

Re: Building a Report Filter using OR instead of AND

Lech_Miszkiewicz — Fri, 13 Mar 2026 03:01:06 GMT

Hi @WeLoveQlik

I agree with your approach. One thing to note though is that such set analysis filter has to be applied to the dimension with the granularity taking into account both of those dimensions as a minimum.

cheers

Lech