Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Maybe like
=sum(if([Customer Business Unit] = 'Global Supply Chain' or Match([Support Group],'iTAC','ProM'),1,0))
The or logic would be as follow:
sum({ <[Support Group] ={'iTAC '}> + <[Support Group] ={'ProM'}> }expression)
Maybe like
=sum(if([Customer Business Unit] = 'Global Supply Chain' or Match([Support Group],'iTAC','ProM'),1,0))
Hey Stefan,
That worked like a charm! Thank you so much!!!!