Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can't You just add another Master Calendar associated to the hire date?, thus having two master calendars
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
Hi Sujan,
Have a look at this document, I know it is for qlikview but it should help
Thanks
Mark
youtube.com/practicalqlik