How do I process an OR logic Operation

[lblackley]

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!

[OmarBenSalem]

The or logic would be as follow:

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

[swuehl · Accepted solution]

Maybe like

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

[lblackley]

Hey Stefan,

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