Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
david777
Contributor II
Contributor II

Count values regardless selection

Hello,

I have the following table.

VisitIDPersonIDYEAR
112014
212015
312016
412017
512018
612018
722015
822016
922017
1032016
1132017
1232017
1332018
1442014
1542015
1642015
1742016
1842018
1952016
2052016


I want to count how many PersonID who had at least two VisitID during the period 2017-2018.

The answer should be 2 (PersonID 1 and PersonID 3) even if I make the selection 2018 for field YEAR.

Can anyone help me with this?


Best regards

0 Replies