Month and Year Date Set Analysis

Fri, 05 Oct 2012 16:54:26 GMT

HI,

I am attaching an Employee Hiring.qvw and there is an Monthly Turnover straight table object where I need an expression that makes this table work. I want the count to include all the employees that have a Date of Hire 'DOH_Date' <= to the CalendarMonthAndYear date and the No longer here 'NLE_Month <= to the CalendarMonthAndYear as well . I used the Master Calendar function from another post and I really don't know if I can use it the way I am trying. Once I get the above working then I divide in the count of the employees who ended in that month of Sep which is 4.

if (([CalendarMonthName])='Sep',Count ({<CalendarMonthAndYear = {"$(<=Date(MonthEnd(Date#(DOH_MonthName, 'MMM YYYY')),'MMM YYYY'))"},CalendarMonthAndYear = {"$(<=Date(MonthEnd(Date#(NLE_MonthName, 'MMM YYYY')),'MMM YYYY'))"}>} Total <CalendarMonthName> EmployeeDirectory.ID))

Then the count of people who left in Sep.

(Count({<NLE_Year={'$(vCurrentYear)'},NLE_Month={'Sep'}>} EmployeeDirectory.ID))

You can see both of these in the attach file. Any help is greatly appreciated.

Thank you and regards,

OnePuttGirl

topic Month and Year Date Set Analysis in QlikView

Month and Year Date Set Analysis