topic Re: Employee Master Query in data model in QlikView

Employee Master Query in data model

vikasmahajan — Tue, 18 Jun 2013 12:26:44 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.

Thanks in Advance.

Vikas Mahajan

Gysbert_Wassenaar — Tue, 18 Jun 2013 17:18:17 GMT

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 — Wed, 19 Jun 2013 03:56:56 GMT

Thanks for Reply I will try the same.

Vikas

vikasmahajan — Wed, 19 Jun 2013 07:58:27 GMT

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