Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

vikasmahajan
Esteemed Contributor

Data Model Question Employee Link

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

4 Replies
Highlighted
Partner
Partner

Re: Data Model Question Employee Link

Hi,

find the attached file.

use this data module.

vikasmahajan
Esteemed Contributor

Re: Data Model Question Employee Link

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

Vikas

Partner
Partner

Re: Data Model Question Employee Link

Hi Vikas Mahajan

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

Not applicable

Re: Data Model Question Employee Link

Hi Vikas,

You should use multiple master calender.

Plz fin Henric blog post..

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

Karthik