Count occurrences

[#1]

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

[Anonymous · Accepted solution]

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.

[#3]

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