Solved: Re: Count occurrences - Qlik Community

Report Inappropriate Content · ‎2012-07-12

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 · ‎2012-07-12

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.

View solution in original post

Anonymous · ‎2012-07-12

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.

Report Inappropriate Content · ‎2012-07-12

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