Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

gsrchowdary
New Contributor

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

Tags (1)
2 Replies
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
buzzy996
Honored Contributor II

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

Gysbert is right..