topic Count occurrences in QlikView

Count occurrences

Thu, 12 Jul 2012 08:38:31 GMT

Hello.

I have two tables called DONOR (key DONOR_ID) and DONATION (DONATION_ID). They are connected via DONOR_ID.

Now I want to count how many Donors(uniqe DONOR_ID) that have exactly 2 donations(DONATION_ID).

How do i achieve this?

Regards

Databyran

Re: Count occurrences

Anonymous — Thu, 12 Jul 2012 08:44:27 GMT

Sounds like you should be able to do something like this:

sum(aggr(if(Count(DONATION_ID)=2,1,0),DONOR_ID))

Count all instance where the number of donation-id's = 2, for every Donor_id and assign them the value 1. Then sum up these ones into the total count.

Re: Count occurrences

Thu, 12 Jul 2012 08:54:16 GMT

Thank you, worked perfect!

Please have a look at this post - maybe you have a solution?

http://community.qlik.com/message/236513#236513

Thank you!

Databyran