Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
sunny_talwar

May be this

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

Anonymous
Not applicable
Author

Thanks a lot!!!