Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get count of people whose joining and exit happend in same day

Hi Friends,

I am looking for who can help me out to get

Count of people who joined an organization and exit same day.?

Ex: if 10 people joined in a company on 18thMarch2015 and their termination happend on same day.In this case i want to get the count as 10.

Thanks,

Siva

2 Replies
Gysbert_Wassenaar

Maybe this: count(distinct if(JoinDate = TerminationDate, EmployeeID))


talk is cheap, supply exceeds demand
buzzy996
Master II
Master II

Gysbert is right..