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.
Thanks a lot for your help. The second soluition is very good.
Do you have any suggestion how to use directly the Dep1 and Dep2 coming from the dimension inside the expression instead of declaring each Sector (one per line).
Is the GetFieldSelections useful in this case ? Can we dynamically create separates expressions using fields of dimension ?