Count to check if count is greater than 1 for one value

[JC_Qlik]

I attempting to count how many people clicked on a particular link more than once. Currently, I have data that shows if they did or did not click the link (yes and no). 

I am able to count the total number of people that has greater than 1 clicks, but not able to count just the people that clicked yes? Here is what I have for a total count of clicks greater than 1. 

Count({<email={"=Count(Clicklink)>=2"} >} distinct email)

I have tried multiple combinations of adding Clicklink = 'Yes', but have not had any luck. The only way I am able to do it is buy using a filter, which will not work in this situation. 

Any help would be greatly appreciated. 

[sunny_talwar · Accepted solution]

May be this

Count({<email = {"=Count({<Clicklink = {'Yes'}>} Clicklink) >= 2"}>} DISTINCT  email)

[JC_Qlik]

Worked like a charm! Thank you very much!