topic Identify Employee Attrition rate in QlikView https://community.qlik.com/t5/QlikView/Identify-Employee-Attrition-rate/m-p/437913#M564444 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>We have a situation wherein the customer want to know whats the attrition rate and with a drill down to the list of employees who are contributing to net employee movement (net of employees quit and joined) for a period of time.</P><P></P><P>We receive a list of employees (Complete list) every month and we have to compare the list between months to identify the movement of employees.</P><P></P><P>Current Month</P><P></P><P>Employee Name</P><P>A</P><P>B</P><P>D</P><P>H</P><P></P><P></P><P>Prev Month</P><P></P><P>Empl</P><P>A</P><P>B</P><P>C</P><P>D</P><P>E</P><P>F</P><P>G</P><P></P><P>From the list we need to identify that Employee C, E,F,G have quit and Emplyee G has joined and display Net movement of (-3) in the bar graph and while clicked on Bar a list of employees should be shown.</P><P></P><P>Can anyone suggest if this can be handled programmatically.</P><P></P><P>Thanks and Regards,</P><P>Raghav</P></BODY></HTML> Mon, 21 Jan 2013 08:38:45 GMT raghavsurya 2013-01-21T08:38:45Z Identify Employee Attrition rate https://community.qlik.com/t5/QlikView/Identify-Employee-Attrition-rate/m-p/437913#M564444 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>We have a situation wherein the customer want to know whats the attrition rate and with a drill down to the list of employees who are contributing to net employee movement (net of employees quit and joined) for a period of time.</P><P></P><P>We receive a list of employees (Complete list) every month and we have to compare the list between months to identify the movement of employees.</P><P></P><P>Current Month</P><P></P><P>Employee Name</P><P>A</P><P>B</P><P>D</P><P>H</P><P></P><P></P><P>Prev Month</P><P></P><P>Empl</P><P>A</P><P>B</P><P>C</P><P>D</P><P>E</P><P>F</P><P>G</P><P></P><P>From the list we need to identify that Employee C, E,F,G have quit and Emplyee G has joined and display Net movement of (-3) in the bar graph and while clicked on Bar a list of employees should be shown.</P><P></P><P>Can anyone suggest if this can be handled programmatically.</P><P></P><P>Thanks and Regards,</P><P>Raghav</P></BODY></HTML> Mon, 21 Jan 2013 08:38:45 GMT https://community.qlik.com/t5/QlikView/Identify-Employee-Attrition-rate/m-p/437913#M564444 raghavsurya 2013-01-21T08:38:45Z