Employee Master Query in data model

[vikasmahajan]

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.

Thanks in Advance.

Vikas Mahajan

[Gysbert_Wassenaar]

If you have two date fields it's easiest to create two calendars. Otherwise you have to create a link table See this discussion for both options.

[vikasmahajan]

Thanks for Reply I will try the same.

Vikas

[vikasmahajan]

I have fail to do this and I also posted new post  in http://community.qlik.com/message/358670#358670

along with my qvw can you help me to modify as per my requirement.

Thanks.

Vikas