Two dates in a single table

[#1]

Hi,

I have an employees table which has hire date and termination date and I have to do analysis on both.I have also created a master calendar but was joing only to Term date so was not able to do analysis on Hire Date.Can you please let me know how to handle this kind of situation.I have read the canonical periods thread but did not understand it well.

Thanks.

[#2]

Can't You just add another Master Calendar associated to the hire date?, thus having two master  calendars

[its_anandrjs]

Hi,

You can read some of this posts

Canonical Date

http://community.qlik.com/message/652846#652846

Regards

Anand

[kiranmanoharrode]

Hi Sujan,

Use interval match for Mapping master Calender's date within Hire date and Termination Date..

this approach will be helpful for you.

Regards,
Kiran

[markodonovan]

Hi Sujan,

Have a look at this document, I know it is for qlikview but it should help

The Master Calendar

Thanks

Mark

youtube.com/practicalqlik