Hi All,
I am in a situation where I have employees master data, columns such as EmpNumber, EffectiveStartDate, EffectiveEndDate, FirstName, LastName, JobTitle, EmployeeType, Salary etc.
We run this report everyday and concatenate all the data and load it in another qvw.
The issue I am facing is, that the customer wants a flag that will help to narrow down only those employees whose data has changed.
sample data below
| RowNo | EmpNo | EffectiveStDt | EffectiveEndDt | FirstN | LastN | JobTitle | EmployeeType | Salary |
|---|
| 1 | 1 | 12/01/15 | 12/01/16 | Rob | M | Service Advisor | Employee | 20000 |
| 2 | 1 | 12/01/16 | 31/12/4712 (oracle date) | Rob | M | Service Manager | Employee | 30000 |
| 3 | 2 | 1/02/14 | 02/02/15 | Mike | E | Project Manager | Employee | 35000 |
| 4 | 2 | 02/02/15 | 31/12/4712 | Mike | E | Project Manager | Ex-Employee | 35000 |
| 5 | 3 | 15/02/14 | 31/12/4712 | Craig | M | IT Manager | Employee | 35000 |
| 6 | 3 | 15/02/14 | 31/12/4712 | Craig | M | IT Manager | Employee | 35000 |
So, if I load above data in qlikview, I want some way to add a flag that points out
- changes in rows 2,4
- changes in columns Job title, Employee Type, salary.
I am able to add individual flags, but I have more than 70 columns, so this would not be feasible. I am looking for a two in one solution.
What the user wants is if they select effective start date and effective end date, they should be able to see both ther employee numbers 1 and 2 and their changes in Rown num: 2 and 4.
Also, I was looking at Slowly Changing Dimension and Interval Match, but since I only have one big fact table, I dont think I can use this approach, can you please advice me if I am right or wrong here?
Any help here would be great. I am struggling to get this thing sorted.
Thank you in advance.
and you will more points 
)
