topic Need help with aggregation in QlikView

Need help with aggregation

dilara_askarova — Wed, 12 Apr 2023 13:51:01 GMT

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 — Wed, 12 Apr 2023 14:23:00 GMT

I think:

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

dilara_askarova — Fri, 14 Apr 2023 16:35:53 GMT

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