Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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!