Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lblackley
New Contributor

How do I process an OR logic Operation

Hello,

I'm really new to Qlik Sense and I am working on populating results in a dashboard.

I currently have:

sum(if([Customer Business Unit] = 'Global Supply Chain',1,0))

as a formula for a KPI box. but I also need to include 3 different values in the count from another source.

I need in the [Support Group] field, to include the values of iTAC & ProM.

This needs to be either or, not an AND operation.

Any assistance would be HUGE!

1 Solution

Accepted Solutions
MVP
MVP

Re: How do I process an OR logic Operation

Maybe like

=sum(if([Customer Business Unit] = 'Global Supply Chain' or Match([Support Group],'iTAC','ProM'),1,0))

3 Replies
omarbensalem
Esteemed Contributor

Re: How do I process an OR logic Operation

The or logic would be as follow:

sum({ <[Support Group] ={'iTAC '}> + <[Support Group] ={'ProM'}> }expression)

MVP
MVP

Re: How do I process an OR logic Operation

Maybe like

=sum(if([Customer Business Unit] = 'Global Supply Chain' or Match([Support Group],'iTAC','ProM'),1,0))

lblackley
New Contributor

Re: How do I process an OR logic Operation

Hey Stefan,

That worked like a charm! Thank you so much!!!!