Common Calendar for Multiple dates in Multiple tables
I have one requirement in Qlikview for HR Data Set where I have multiple Date field in 2 different tables. (Requisition data & Candidate Data)
Now I want to create a common calendar corresponding to both the tables. Somehow I tried concatenation statement against each date field but that is duplicating my data. Please help me with the solution of how to implement common calendar concept in this case. If possible through any QVW file. I am attaching the sample data sheet for same.