Help

[panipat1990]

Hi Team,

I have  a requirrment. I have a Fact table where Date of joining(DOJ) Field And Retirement date(Field)..And another  date field name is (leaving date) and Confirmation Date Field.is coming from master..I Want to make one common date to connect with my master calender. For This I am sharing excel.kindly help me for solving this requirement.

Excel Master is my master Table

excel_Transaction Is my fact table.and Emp Id is common key between two table.

[panipat1990]

is this possible in qlikview.

[#3]

Hi,

Is this what you're looking for

[prma7799]

What is your exact retirement ?

[jonathandienst]

This is how to link multiple dates to a single calendar:

Canonical Date

[Digvijay_Singh]

Your confirm date seems out of order, can you check if it is correct in attached sample.

[arasantorule]

Hi,

I am thinking the below way by spliting tables into 4,

1. Emplyee, Leaving Date

2. Employee, Joining Date

3. Employee, Retirement Date

4. Employee, Confirmation Date

Create a link table to concatenate all the tables using Employee ID and Date with the common date flag filed.

Create a Calendar using the date flag available in the link table.

Hope this helps.

[Digvijay_Singh · Accepted solution]

You may use below attached sample -

[Digvijay_Singh]

Small modification in below to correct date format

[panipat1990]

Can you share me one qvw