topic Re: Data Model Question Employee Link in QlikView

Data Model Question Employee Link

vikasmahajan — Wed, 19 Jun 2013 07:56:57 GMT

Dear All,

I have Employee master with Date of join and salary transactions is linked with empid and salary is linked to master calender

as per posting date transactions in my payroll module.

Now :- Requirement is that i want to join date of join with my master calender , I try to rename field and linked but loop is coming

can any one have idea how to achive the same in data model.

I have attach my qvw some can please modify and send me as per my requirement.

Thanks in Advance.

Vikas Mahajan

kumarnatarajan — Wed, 19 Jun 2013 08:06:25 GMT

Hi,

find the attached file.

use this data module.

vikasmahajan — Wed, 19 Jun 2013 08:09:34 GMT

Thanks for Reply but how employee will link to fact table ? This solution is not fesible.

Vikas

kumarnatarajan — Wed, 19 Jun 2013 08:19:47 GMT

Ok, find the attached file. i think you are looking this module.

Wed, 19 Jun 2013 08:45:16 GMT

Hi Vikas,

You should use multiple master calender.

Plz fin Henric blog post..

Karthik