Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikers,
We are going to implement HR module at one client.
The scenario is, We are having Employee information like Date Of Joining, Date of Leaving, Dept and other information related to the employee.
Now we don't have any transaction date field related to employees and reports to be created are like below:
Need your advice and suggestions on how to build a data model in Qliksense so that we can work with calendar flexibility
Many Thanks in advance..........
I think you need 2 master calendar here. Because, you don't have transaction date. Create one calendar for DOJ and other is for DOL
Hi Ashish,
Check out this post by hic that sets out very clearly when multiple calendars will meet your needs and when you may need something extra called a canonical calendar.
cheers
Andrew
Ashish,
if you decide to go down the route of creating a single master calendar, it might be useful to think about what events are associated with your employees. In this case this might be a joining event and (possibly) a leaving event.
If you then create a fact table based on these two event types, it's a simple matter to create a single date field, and a couple of flags, one for a join event and one for a leave event. With this in place, you can chart your joiners, leavers and headcount (using accumulation).
Marcus