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

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
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.