Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kshitijas
New Contributor III

Employee present or absent?

Hello everyone,

               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?

Thanks!!

2 Replies
MVP
MVP

Re: Employee present or absent?

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

New/Lost/Returning/Loyal Customers

or

Intervalmatch Count Open Items

rnt
Valued Contributor

Re: Employee present or absent?

Emp:

Load *, MakeDate(Year,Month) As MonthDate;

Load * inline [

Employee,Year,Month

A,2016,1

B,2016,1

A,2016,2

B,2016,2

A,2016,3

A,2016,4

];

LastMonthWorked:

Load *, Year(FinalDate) &'-'&Month(FinalDate) As FinalMonth;

Load

Employee, Max(MonthDate) As FinalDate

Resident Emp Group By Employee;

Result of LastMonthWorked is:
A     2016-Apr

B     2016-Feb