Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
stepguti
Contributor
Contributor

set analysis with aggr()

I need to get a distinct count for sum billed of all claims where billed > $1000.  Can someone help me write this syntax.  I'm guessing I'll start with something like this 

Count(Aggr(Sum(BilledAmount), ClaimID))

but not sure how to incorporate set analysis to only get the distinct claim count where sum billed amount >$1000.

 

Thanks in advance! 

2 Replies
Channa
Specialist III
Specialist III

Count(IF(Aggr(Sum(BilledAmount), ClaimID)>100,ClaimID)

Channa
pradosh_thakur
Master II
Master II

Count(Distinct {<ClaimID={"=Sum(BilledAmount)>1000"}>} ClaimID)
Learning never stops.