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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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