topic Re: Number of employees month by month in QlikView https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243458#M517959 <HTML><HEAD></HEAD><BODY><P>Thank you&nbsp; very much !</P><P>Regards,</P><P></P><P>Sarah</P></BODY></HTML> Mon, 14 Nov 2016 09:18:36 GMT 2016-11-14T09:18:36Z Number of employees month by month https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243455#M517956 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I’m trying to make a human ressources dashboard. I am having issues doing a chart which represents the number of employees month by month.</P><P></P><P>Here’s a sample of my data :</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none; padding: 0 5.4pt 0 5.4pt;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><P>Name</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><P>Date of employment</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><P>Date of exit</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><OL style="list-style-type: upper-alpha;"><LI>M. X</LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><P>01/01/2016</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><P>-</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><OL style="list-style-type: upper-alpha;"><LI>Mrs. C</LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><P>05/06/2014</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><P>31/10/2016</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><OL style="list-style-type: upper-alpha;"><LI>M. Y</LI></OL></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><P>03/09/2011</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="205"><P>-</P></TD></TR></TBODY></TABLE><P></P><P>How can I do that ?</P><P></P><P>I thought about that kind of chart :</P><P></P><P></P><P><SPAN lang="EN-GB" style="font-size: 12.0pt; font-family: 'Times New Roman';"></SPAN></P><P><SPAN lang="EN-GB" style="font-size: 12.0pt; font-family: 'Times New Roman';"><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143807_Capture.PNG" style="height: auto;" /></SPAN></P><P><SPAN lang="EN-GB" style="font-size: 12.0pt; font-family: 'Times New Roman';"><BR /></SPAN></P><P><SPAN lang="EN-GB" style="font-size: 12.0pt; font-family: 'Times New Roman';">&nbsp; <SPAN lang="EN-GB" style="font-size: 12.0pt; font-family: 'Times New Roman';">Thanks in advance,</SPAN></SPAN></P></BODY></HTML> Mon, 14 Nov 2016 08:01:22 GMT https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243455#M517956 2016-11-14T08:01:22Z Re: Number of employees month by month https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243456#M517957 <HTML><HEAD></HEAD><BODY><P>Use this dimension and expression</P><P></P><P>Dim:- Month</P><P></P><P>Expre:- Count(Name)</P><P></P><P>Regards</P><P>Anand</P></BODY></HTML> Mon, 14 Nov 2016 08:10:11 GMT https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243456#M517957 its_anandrjs 2016-11-14T08:10:11Z Re: Number of employees month by month https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243457#M517958 <HTML><HEAD></HEAD><BODY><P>Hi Sarah,</P><P></P><P>Please find attached the qvw. I have used interval match concept.</P><P>Hope this helps you.</P></BODY></HTML> Mon, 14 Nov 2016 09:15:51 GMT https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243457#M517958 Anonymous 2016-11-14T09:15:51Z Re: Number of employees month by month https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243458#M517959 <HTML><HEAD></HEAD><BODY><P>Thank you&nbsp; very much !</P><P>Regards,</P><P></P><P>Sarah</P></BODY></HTML> Mon, 14 Nov 2016 09:18:36 GMT https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243458#M517959 2016-11-14T09:18:36Z Re: Number of employees month by month https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243459#M517960 <HTML><HEAD></HEAD><BODY><P>Most Welcome... <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 14 Nov 2016 09:21:14 GMT https://community.qlik.com/t5/QlikView/Number-of-employees-month-by-month/m-p/1243459#M517960 Anonymous 2016-11-14T09:21:14Z