topic Re: Link DOJ and Salary Date to Master Calender in QlikView https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771096#M273699 <HTML><HEAD></HEAD><BODY><P>I have done it by using IntervalMatch... If your requirement doesn't fulfilled, let me know, will try with link table...</P></BODY></HTML> Wed, 25 Feb 2015 07:52:59 GMT MK_QSL 2015-02-25T07:52:59Z Link DOJ and Salary Date to Master Calender https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771091#M273694 <HTML><HEAD></HEAD><BODY><P>Hii</P><P>I have problem with master calender how do I link DOJ date of join of Employee Master and Salary Date with Calender Also I want to Link EMPID and EMPID Of salary table how to achieve the same.</P><P></P><P>Please find attached data model</P><P></P><P></P><P>Vikas</P></BODY></HTML> Mon, 23 Feb 2015 12:15:15 GMT https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771091#M273694 vikasmahajan 2015-02-23T12:15:15Z Re: Link DOJ and Salary Date to Master Calender https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771092#M273695 <HTML><HEAD></HEAD><BODY><P>Employee Table must be joined by Employee ID with Salary table...</P><P>Create DOJ as DATE and 'DOJ' as Flag in EmployeeTable</P><P>Create [Salary Date] as Date and 'SalaryDate' as Flag in Salary Table...</P><P></P><P>Now create a Mater Calendar with DATE field...</P><P>You will get a Synthetic Key due to the two common field in both tables... DATE and Flag..</P><P>Create a link table or use concatenation method to remove the key..</P></BODY></HTML> Mon, 23 Feb 2015 12:27:32 GMT https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771092#M273695 MK_QSL 2015-02-23T12:27:32Z Re: Link DOJ and Salary Date to Master Calender https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771093#M273696 <HTML><HEAD></HEAD><BODY><P>Dear Mr.Manish ,</P><P>Many Thanks for valuable Input Please can you guide me how to remove syn key&nbsp; as per your instruction I have created link got syn key.</P><P></P><P>Your expert guidance is required.</P><P></P><P></P><P>Vikas</P></BODY></HTML> Tue, 24 Feb 2015 03:41:58 GMT https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771093#M273696 vikasmahajan 2015-02-24T03:41:58Z Re: Link DOJ and Salary Date to Master Calender https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771094#M273697 <HTML><HEAD></HEAD><BODY><P>Provide your sample apps... Would work on the same and come back to you...</P></BODY></HTML> Tue, 24 Feb 2015 08:33:10 GMT https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771094#M273697 MK_QSL 2015-02-24T08:33:10Z Re: Link DOJ and Salary Date to Master Calender https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771095#M273698 <HTML><HEAD></HEAD><BODY><P>Please find attached demo apps I have created Please help me to achieve the same after your solution I shall try this logic on Live </P><P></P><P>Thanks</P><P></P><P>Vikas</P></BODY></HTML> Wed, 25 Feb 2015 06:11:55 GMT https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771095#M273698 vikasmahajan 2015-02-25T06:11:55Z Re: Link DOJ and Salary Date to Master Calender https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771096#M273699 <HTML><HEAD></HEAD><BODY><P>I have done it by using IntervalMatch... If your requirement doesn't fulfilled, let me know, will try with link table...</P></BODY></HTML> Wed, 25 Feb 2015 07:52:59 GMT https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771096#M273699 MK_QSL 2015-02-25T07:52:59Z Re: Link DOJ and Salary Date to Master Calender https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771097#M273700 <HTML><HEAD></HEAD><BODY><P>Dear Manish,</P><P></P><P>in live scenario&nbsp; following&nbsp; lines held script and creating lot or records&nbsp; and creating performance issues</P><P></P><P>Left Join (EMP) Load PAY_DATE Resident SALARY;</P><P>Drop Field PAY_DATE From SALARY;</P><P></P><P>Please you give me using Link approach.</P><P></P><P>Vikas</P></BODY></HTML> Wed, 25 Feb 2015 09:33:51 GMT https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771097#M273700 vikasmahajan 2015-02-25T09:33:51Z Re: Link DOJ and Salary Date to Master Calender https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771098#M273701 <HTML><HEAD></HEAD><BODY><P>FYI</P></BODY></HTML> Wed, 25 Feb 2015 10:00:28 GMT https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771098#M273701 MK_QSL 2015-02-25T10:00:28Z Re: Link DOJ and Salary Date to Master Calender https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771099#M273702 <HTML><HEAD></HEAD><BODY><P>Dear Manish,</P><P></P><P>After checking&nbsp; this in live I got solution which I am looking for </P><P></P><P>Many Thanks</P><P></P><P>Vikas</P></BODY></HTML> Wed, 25 Feb 2015 11:11:00 GMT https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771099#M273702 vikasmahajan 2015-02-25T11:11:00Z Re: Link DOJ and Salary Date to Master Calender https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771100#M273703 <HTML><HEAD></HEAD><BODY><P>Dear Manish,</P><P>Due to your support and expert guide lines I able to complete Hr Module , I really appreciate your help </P><P>Thanking once again.</P><P>Good Day</P><P></P><P>Vikas</P></BODY></HTML> Sat, 28 Feb 2015 06:55:37 GMT https://community.qlik.com/t5/QlikView/Link-DOJ-and-Salary-Date-to-Master-Calender/m-p/771100#M273703 vikasmahajan 2015-02-28T06:55:37Z