topic Re: how to make calendar based on two date fields. in QlikView

how to make calendar based on two date fields.

Wed, 25 Feb 2015 12:03:12 GMT

Hi Friends,

i have two dates from two table first one is DOJ from employeemaster and Pay_DATE from fact salary .i have created calendar from doj , i want to create calendar from both date fields doj and pay_date.

I am confused in how to merge both fields and make a calendar .

Re: how to make calendar based on two date fields.

MK_QSL — Wed, 25 Feb 2015 12:09:06 GMT

Looks similar post to me...

Check my reply there... Looks like interview question 🙂

Link DOJ and Salary Date to Master Calender

Re: how to make calendar based on two date fields.

CELAMBARASAN — Wed, 25 Feb 2015 12:33:36 GMT

Hi,

Here, you just need to form a link table between Employee master, Salary and Calendar. See Below

Don't disturb any tables as you have right now, Rename the Date field from Calendar table as CommonDate and follow the steps.

1. Create a table with fields Empid, DOJ and DOJ as CommonDate from Employee master. Lets say table name as LinkTable

2. Concatenate the data from Salary table with fields like Empid, Pay_Date and Pay_Date as CommonDate.

Now you will get the Calendar as desired.

Re: how to make calendar based on two date fields.

Wed, 25 Feb 2015 12:41:55 GMT

no its not for interview but ur answer is correct.

Re: how to make calendar based on two date fields.

MK_QSL — Wed, 25 Feb 2015 13:23:57 GMT

Please close the thread by selection appropriate answer..