Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Two dates in a single table

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.

4 Replies
Not applicable

Re: Two dates in a single table

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

its_anandrjs
Not applicable

Re: Two dates in a single table

Hi,

You can read some of this posts

Canonical Date

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

Regards

Anand

kiranmanoharrod
Not applicable

Re: Two dates in a single table

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
Not applicable

Re: Two dates in a single table

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