Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You may use below attached sample -
is this possible in qlikview.
Hi,
Is this what you're looking for
What is your exact retirement ?
This is how to link multiple dates to a single calendar:
Your confirm date seems out of order, can you check if it is correct in attached sample.
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.
You may use below attached sample -
Small modification in below to correct date format
Can you share me one qvw