Need help with aggregation

[dilara_askarova]

I have not used Qlik Aggr function in a while and can't figure this problem out. 

Need to count clients who spent more than 10K in the past year. 

I figured I can use Aggr(SUM(Total_Paid), Client_ID) > 10000

But how can I use it to count Client_IDs?

Cient_ID is not a dimension in the table. 

Thanks 

[rwunderlich · Accepted solution]

I think:

Count({<Client_ID={"=Sum(Total_Paid)>10000"}>}Distinct Client_ID)

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[dilara_askarova]

Thanks, haven't done this in a while and completely spaced out that I can use SUM in set analysis.