Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
please guys, please any help any suggestion, would be greatly appreciated (you answer might be marked as correct answer and you will more points
)
Hi,
I am currently facing the same issue, did you find a way to make it work?
brg,
Ben