How to flag changed/ updated data?

Thu, 31 Mar 2016 16:42:59 GMT

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.

Re: How to flag changed/ updated data?

Fri, 01 Apr 2016 14:21:41 GMT

please guys, please any help any suggestion, would be greatly appreciated (you answer might be marked as correct answer and you will more points )

Re: How to flag changed/ updated data?

Bendikl — Wed, 30 Nov 2022 08:50:03 GMT

Hi,

I am currently facing the same issue, did you find a way to make it work?

brg,

Ben

topic How to flag changed/ updated data? in QlikView

How to flag changed/ updated data?

Re: How to flag changed/ updated data?

Re: How to flag changed/ updated data?