NOT LOOSE RELATION WITH TABLE

[fkeuroglian]

Hi all, i have a situation...

I have a fact table that have DATE,PRODUCT, COD_EMPLOYEE, and I have another table that is the master table of Employee(contain COD_EMPLOYEE and DESC_EMPLOYEE).

All cod employee are fix to the master table employee, ok but if one of my employees leave the company, I loose the relation in my fact tables because he do not appear in my master employee table.

what can i do to persiste the relation in spite of loose this relation, i do want to keep the information no mater the employee is or not in the master table of employee.

Thank you a lot!

i attached a simple example and a excel that contain 2 sheet(fact table and master employee)

thank you a lot

Fernando

[whiteline]

Hi.

"i do want to keep the information no mater the employee is or not in the master table of employee"

It seems that you've already kept it. Since your fact table always contain all employees.

[fkeuroglian]

Hi Whiteline.

I have a fact table yes, but if a employee is removed for my master employee, in qlikview desappear my relation and show only a line ( - ).

if you was my employee , i want to see you and your relation in the fact tables

thank you a lot

Fernando

[mangalsk]

Hello,

If we remove empcode then it will give - instead of empcode.

So you can instead create a column where you can maintain flag for ex-employees.

That way you will not loss data and instead can see for current and ex employee also.

Regards

[whiteline]

Hi.

And to do it (see) you have to load the names somewhere.

I suggest you to add a flag 'dismissed' and load all of the employees that is in fact table into master table.

Sooner or later you'll need also the date when the employee was dismissed.