topic Outstanding Jobs per Month from 01 in QlikView https://community.qlik.com/t5/QlikView/Outstanding-Jobs-per-Month-from-01/m-p/805927#M284520 <HTML><HEAD></HEAD><BODY><P>I have a table that contains jobs from 1st Jan 2104 up until today.</P><P></P><P>I have been asked to supply the number of jobs that where outstanding at the end of each month from Jan 2014 to March 2015.</P><P></P><P>The Jobs Table is as follows:</P><P></P><P>JobID</P><P>Status (either open or closed)</P><P>DateCreated</P><P>DateClosed</P><P></P><P>So if I have the following jobs</P><P>ID&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp; DateCreated&nbsp;&nbsp;&nbsp;&nbsp; DateClosed</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp;&nbsp;&nbsp;&nbsp; 2014-01-15&nbsp;&nbsp;&nbsp;&nbsp; 2014-01-28</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; open&nbsp;&nbsp;&nbsp;&nbsp; 2014-01-26</P><P>3&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp;&nbsp;&nbsp;&nbsp; 2014-01-27&nbsp;&nbsp;&nbsp;&nbsp; 2014-03-15</P><P>4&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp;&nbsp;&nbsp;&nbsp; 2014-02-16&nbsp;&nbsp;&nbsp;&nbsp; 2014-03-21</P><P>5&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp;&nbsp;&nbsp;&nbsp; 2014-02-18&nbsp;&nbsp;&nbsp;&nbsp; 2014-04-22</P><P></P><P>I would expect the following at the end of each month</P><P>Jan 2014 outstanding = 2 (Jobs 2 &amp; 3)</P><P>Feb 2014 outstanding = 4 (Jobs 2, 3, 4 &amp; 5)</P><P>Mar 2014 outstanding = 2<SPAN style="font-size: 13.3333330154419px;"> (Jobs 2 &amp; 5)</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Apr 2014 <SPAN style="font-size: 13.3333330154419px;">outstanding = 1</SPAN><SPAN style="font-size: 13.3333330154419px;"> (Job 2)</SPAN></SPAN></P><P></P><P>Cheers</P><P>Adrian</P></BODY></HTML> Fri, 27 Mar 2015 11:42:34 GMT atoz1158 2015-03-27T11:42:34Z Outstanding Jobs per Month from 01 https://community.qlik.com/t5/QlikView/Outstanding-Jobs-per-Month-from-01/m-p/805927#M284520 <HTML><HEAD></HEAD><BODY><P>I have a table that contains jobs from 1st Jan 2104 up until today.</P><P></P><P>I have been asked to supply the number of jobs that where outstanding at the end of each month from Jan 2014 to March 2015.</P><P></P><P>The Jobs Table is as follows:</P><P></P><P>JobID</P><P>Status (either open or closed)</P><P>DateCreated</P><P>DateClosed</P><P></P><P>So if I have the following jobs</P><P>ID&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;&nbsp; DateCreated&nbsp;&nbsp;&nbsp;&nbsp; DateClosed</P><P>1&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp;&nbsp;&nbsp;&nbsp; 2014-01-15&nbsp;&nbsp;&nbsp;&nbsp; 2014-01-28</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; open&nbsp;&nbsp;&nbsp;&nbsp; 2014-01-26</P><P>3&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp;&nbsp;&nbsp;&nbsp; 2014-01-27&nbsp;&nbsp;&nbsp;&nbsp; 2014-03-15</P><P>4&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp;&nbsp;&nbsp;&nbsp; 2014-02-16&nbsp;&nbsp;&nbsp;&nbsp; 2014-03-21</P><P>5&nbsp;&nbsp;&nbsp;&nbsp; closed&nbsp;&nbsp;&nbsp;&nbsp; 2014-02-18&nbsp;&nbsp;&nbsp;&nbsp; 2014-04-22</P><P></P><P>I would expect the following at the end of each month</P><P>Jan 2014 outstanding = 2 (Jobs 2 &amp; 3)</P><P>Feb 2014 outstanding = 4 (Jobs 2, 3, 4 &amp; 5)</P><P>Mar 2014 outstanding = 2<SPAN style="font-size: 13.3333330154419px;"> (Jobs 2 &amp; 5)</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">Apr 2014 <SPAN style="font-size: 13.3333330154419px;">outstanding = 1</SPAN><SPAN style="font-size: 13.3333330154419px;"> (Job 2)</SPAN></SPAN></P><P></P><P>Cheers</P><P>Adrian</P></BODY></HTML> Fri, 27 Mar 2015 11:42:34 GMT https://community.qlik.com/t5/QlikView/Outstanding-Jobs-per-Month-from-01/m-p/805927#M284520 atoz1158 2015-03-27T11:42:34Z