Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
JC_Qlik
New Contributor

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

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. 

1 Solution

Accepted Solutions

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

May be this

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

View solution in original post

2 Replies

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

May be this

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

View solution in original post

JC_Qlik
New Contributor

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

Worked like a charm! Thank you very much!