topic Re: HR Dashboard in QlikView https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851205#M298556 <HTML><HEAD></HEAD><BODY><P>Hi Shreya,</P><P></P><P>you might be able to get inspiration from Qlikview Demo file "Human Resources"</P></BODY></HTML> Thu, 16 Apr 2015 14:47:04 GMT jpenuliar 2015-04-16T14:47:04Z HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851201#M298552 <HTML><HEAD></HEAD><BODY><P>If I want to display the number of employees hired each year, how should i do that?</P><P>Say I have a field called year, and another field called employement date?</P></BODY></HTML> Thu, 16 Apr 2015 14:36:47 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851201#M298552 2015-04-16T14:36:47Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851202#M298553 <HTML><HEAD></HEAD><BODY><P>see this,</P></BODY></HTML> Thu, 16 Apr 2015 14:44:12 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851202#M298553 buzzy996 2015-04-16T14:44:12Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851203#M298554 <HTML><HEAD></HEAD><BODY><P>I guess you have a table which lists each employee (by EmployeeID) and their employment date ? Don't forget that several people may start on the same day.</P><P></P><P>Then create a straight table type of Chart, with year of employment as the dimension and COUNT(DISTINCT EmployeeID) as an expression.</P></BODY></HTML> Thu, 16 Apr 2015 14:46:28 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851203#M298554 richard_chilvers 2015-04-16T14:46:28Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851204#M298555 <HTML><HEAD></HEAD><BODY><P>You can create flag inside script to find out the employee joined in particular year... Please provide some sample data to work..</P></BODY></HTML> Thu, 16 Apr 2015 14:46:35 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851204#M298555 MK_QSL 2015-04-16T14:46:35Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851205#M298556 <HTML><HEAD></HEAD><BODY><P>Hi Shreya,</P><P></P><P>you might be able to get inspiration from Qlikview Demo file "Human Resources"</P></BODY></HTML> Thu, 16 Apr 2015 14:47:04 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851205#M298556 jpenuliar 2015-04-16T14:47:04Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851206#M298557 <HTML><HEAD></HEAD><BODY><P>You can at the expression level or at the script level. Please find the attachment</P></BODY></HTML> Thu, 16 Apr 2015 15:11:08 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851206#M298557 2015-04-16T15:11:08Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851207#M298558 <HTML><HEAD></HEAD><BODY><P>I am unable to open it, Could you screenshot it maybe?</P></BODY></HTML> Thu, 16 Apr 2015 15:29:10 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851207#M298558 2015-04-16T15:29:10Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851208#M298559 <HTML><HEAD></HEAD><BODY><P>hi,are u tried the one I attached in first post?</P></BODY></HTML> Thu, 16 Apr 2015 15:32:26 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851208#M298559 buzzy996 2015-04-16T15:32:26Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851209#M298560 <HTML><HEAD></HEAD><BODY><P>Yea, Can't open either.</P></BODY></HTML> Thu, 16 Apr 2015 15:34:25 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851209#M298560 2015-04-16T15:34:25Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851210#M298561 <HTML><HEAD></HEAD><BODY><P>try with these files</P></BODY></HTML> Thu, 16 Apr 2015 15:48:11 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851210#M298561 buzzy996 2015-04-16T15:48:11Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851211#M298562 <HTML><HEAD></HEAD><BODY><P>Are you using the Personal Desktop Edition?</P></BODY></HTML> Thu, 16 Apr 2015 15:58:39 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851211#M298562 2015-04-16T15:58:39Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851212#M298563 <HTML><HEAD></HEAD><BODY><P>Yes.</P></BODY></HTML> Thu, 16 Apr 2015 16:16:21 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851212#M298563 2015-04-16T16:16:21Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851213#M298564 <HTML><HEAD></HEAD><BODY><P>are u tried these files?</P></BODY></HTML> Thu, 16 Apr 2015 16:21:03 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851213#M298564 buzzy996 2015-04-16T16:21:03Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851214#M298565 <HTML><HEAD></HEAD><BODY><P>okie,try this way,</P><P>i think u can able to download the above attached excel file/else u can use ur own data.</P><P></P><P>1. dimension: <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">called year</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">2. expression: =count(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">called year</SPAN>)</SPAN></P></BODY></HTML> Thu, 16 Apr 2015 16:26:55 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851214#M298565 buzzy996 2015-04-16T16:26:55Z Re: HR Dashboard https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851215#M298566 <HTML><HEAD></HEAD><BODY><P>Find the screen shot in the word</P></BODY></HTML> Thu, 16 Apr 2015 16:28:24 GMT https://community.qlik.com/t5/QlikView/HR-Dashboard/m-p/851215#M298566 2015-04-16T16:28:24Z