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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
ensoliman20
Contributor
Contributor

Selecting Distinct ID in multiple selection sets and count total

i want to find of count of people who completed both visit 17 and 23 together the distinct so total if 17 and 23 selected is 2 

 

ID Visit

1 17

1 23

2 17

3 17

2 23 

1 Reply
PriyankaShivhare
Creator II
Creator II

 

sum(if(aggr(count(Distinct Visit),ID)=2,1) )

Hope This Helps!

Thanks,

Priyanka