topic Re: NOT LOOSE RELATION WITH TABLE in QlikView

NOT LOOSE RELATION WITH TABLE

fkeuroglian — Fri, 04 Apr 2014 02:45:04 GMT

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

Re: NOT LOOSE RELATION WITH TABLE

whiteline — Fri, 04 Apr 2014 05:30:19 GMT

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.

Re: NOT LOOSE RELATION WITH TABLE

fkeuroglian — Fri, 04 Apr 2014 12:42:09 GMT

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

Re: NOT LOOSE RELATION WITH TABLE

mangalsk — Fri, 04 Apr 2014 13:10:53 GMT

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

Re: NOT LOOSE RELATION WITH TABLE

whiteline — Fri, 04 Apr 2014 13:59:27 GMT

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.