Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. 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.