Upload historical info not associated to master items
Hi everyone, I'm newbie in the whole Qlik Sense World and I need help.
I'm building an HR dashboard, my master items are all the information associated with employees, however, in my charts, I need to show the number of employees that existed in specific months. This information is a fixed value and hasn't been associated to this app.
There are several tables like this, I'm willing to compare per Years (14-15,15-16...) different variables> months, countries, are range, etc.
Registers per Employee.
I don't have any idea how to relate both information, is there a way to create a measure for each crop year, or would it be better to create an association in the data manager? How can I bring into visualization information which is from historical fixed data?
You should consider adding dummy records representing the missing years; If my interpretation of your first screenshot is accurate, you don't have data for the years 2014-2015 and 2015-2016, here you have two options, adding a single dummy record for the year 2014-2015 and another for the year 2015-2016; or adding dummy employees to the master data as many as required to fill those years; the single summary record is the one I had used.
Hope this helps,
Arnaldo Sandoval A journey of a thousand miles begins with a single step.
So I use the 2 dates Attrition or Hiring to distribute the employees in different years periods. However, to calculate the total of people who were "actives" i don´t know how to articulate the information so it appears the same numbers as shown in the first table.