Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
JC_Qlik
Contributor
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
sunny_talwar

May be this

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

View solution in original post

2 Replies
sunny_talwar

May be this

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

View solution in original post

JC_Qlik
Contributor
Contributor
Author

Worked like a charm! Thank you very much!