Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Common Calendar for Multiple dates in Multiple tables

Hello Friends.

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.

Thanks in Advance.


Regards


Amit Sharma

1 Reply
ahaahaaha
Honored Contributor

Re: Common Calendar for Multiple dates in Multiple tables

Hi,

May be this help?

Canonical Date

Regards,

Andrey