Hi this is like base churn which i found when using SQL it was best to split the two sets (in qlikviews case load as different tables and then join back on the employee, this is what i did in the Churn.qvw by modifying the script but have also created one which just uses set analysis this is Churn2.qvw which seems to do the job.