Building a Report Filter using OR instead of AND

[JfrankGroundSystems]

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?

[WeLoveQlik]

Hello!

try this Set analysis

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

[Lech_Miszkiewicz]

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

[Lech_Miszkiewicz]

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