Count of Not present Emp in current Month.

[lalitkgehlot89]

Hi,

In provide sample data I want to check the count of Emp who was not present in last month but not in current Month.

In given date Empcode -3 is not in Mar18,

[tresesco]

You mean, emp in current month but not in last month? Where (textbox, chart...) and how (selection..) do you want to see the output?

[lalitkgehlot89]

Hi Tresesco,

Emp in last month but not in current month.  i want to see it text box all emp count, in chart all emp who was in last month but not in current month with the month selection.

[agastya]

Hi lalit ,

Count({<Month_tabl66={$(=max(Month_tabl66))},EmpCode=E({<Month_tabl66={$(=max(Month_tabl66)-1)}>})>}EmpCode)

[Anonymous]

did you mean present last month, but not in current month?

[lalitkgehlot89]

yes. Present was in last month not in last month.

[lalitkgehlot89]

Hi Vishal,

What is Month_tabl66 is here?

could you provide your working QVW.

[agastya]

month(Date) as Month_tabl66

[agastya]

I think you just want missing EmpCode count right?

[tresesco]

Try like:

=Concat(DISTINCT {<Month,EmpCode=P({1<Month={"$(=Month(AddMonths(Max(Date),-1)))"}>})> - <Month,EmpCode=P(EmpCode)>} EmpCode, ',')

Use count() instead for count of the members.