topic Count based on Sum in QlikView

Count based on Sum

gerhardl — Tue, 16 Apr 2013 13:13:22 GMT

Hi There,

If I have about a million Account Number, each with multiple Transactions, then I can easily calculate each of their total spending by using Account No as dimension, and the expression sum([Trans Amount).

I want to know if I can create a table, where I count the number of Account who have spent within certain brackets. For instance, count the number of accounts where the sum of their Transaction Amounts is between 0 and 100. Then count the number of accounts where the sum of their Transaction Amounts is between 100 and 1000, etc.

Please let me know if this is possible.

Thanks,

Gerhard

Re: Count based on Sum

Gysbert_Wassenaar — Tue, 16 Apr 2013 14:41:44 GMT

It's possible. See attached example.

Re: Count based on Sum

gerhardl — Wed, 17 Apr 2013 06:12:03 GMT

Hi,

Sorry, I always forget to mention that I have QV Personal Edition - so cannot open your example.

P.S. to the moderators - The email notification I got telling me about this reply said that it was received from "Sara Leslie"

Re: Count based on Sum

Miguel_Angel_Baeyens — Wed, 17 Apr 2013 06:16:08 GMT

Hi,

To your PS Yes, you may be getting the name of the moderator approving your content. Hope it will be fixed soon.

Regards,

Miguel