Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

smantaci
New Contributor

Sum If Count in Misure Expression

Hello to All!

I want a measure that counts only Incident_Number where the number of ACT_Call_Incident_Relationship.Call_Request_ID is = 1.

I wrote in this way

Sum(If(Count([ACT_Call_Incident_Relationship.Call_Request_ID])=1 and Count(DISTINCT Incident_Number)=1,1,0))

But I get an error in the expression.

  

Incident_NumberCall_Request_ID
Inc001Call_re01
Inc001Call_re02
Inc001Call_re03
Inc002Call_re04
Inc003Call_re05
Inc003Call_re06
Inc004Call_re07
Inc004Call_re08
Inc005

Call_re09

The result should be 2

Can someone help me with this matter?

2 Replies
Highlighted
MVP
MVP

Re: Sum If Count in Misure Expression

May be this

Count(DISTINCT {<Incident_Number = {"=Count([ACT_Call_Incident_Relationship.Call_Request_ID]) = 1"}>} Incident_Number)

smantaci
New Contributor

Re: Sum If Count in Misure Expression

Thanks a lot!!!

Community Browser