Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vikasmahajan
Not applicable

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
kumarnatarajan
Not applicable

Re: Data Model Question Employee Link

Hi,

find the attached file.

use this data module.

vikasmahajan
Not applicable

Re: Data Model Question Employee Link

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

Vikas

kumarnatarajan
Not applicable

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