Discussion board where members can learn more about Qlik Sense App Development and Usage.
My question is that i have data with months and their employee Id, i want to find the diffrence between the employee id with respect to months.
Eg. some of the employee Id is present in Jan and some of the employee Id are not there in Feb that means they have left the company,how will i come to know which employee left in that month?
There are different approaches:
a) just make selections in month to see the existing and not existing id, or in an id to see the month with an relation
b) have a look at something like
Intervalmatch Count Open Items
Load *, MakeDate(Year,Month) As MonthDate;
Load * inline [
Load *, Year(FinalDate) &'-'&Month(FinalDate) As FinalMonth;
Employee, Max(MonthDate) As FinalDate
Resident Emp Group By Employee;
Result of LastMonthWorked is:A 2016-Apr