topic Two dates in a single table in Visualization and Usability

Two dates in a single table

Thu, 15 Jan 2015 00:25:05 GMT

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.

Re: Two dates in a single table

Thu, 15 Jan 2015 04:34:49 GMT

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

Re: Two dates in a single table

its_anandrjs — Thu, 15 Jan 2015 04:58:40 GMT

Hi,

You can read some of this posts

Canonical Date

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

Regards

Anand

Re: Two dates in a single table

kiranmanoharrode — Thu, 15 Jan 2015 07:34:00 GMT

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

Re: Two dates in a single table

markodonovan — Thu, 15 Jan 2015 10:12:12 GMT

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