topic Deriving Quarter from date in QlikView https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888063#M1011524 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have Date data in excel file in <SPAN style="font-size: 13.3333330154419px;">YYYYMMDD format.</SPAN></P><P>Used this function to convert to date format - </P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14297592136631336" jivemacro_uid="_14297592136631336"> <P>Date#('20131230','YYYYMMDD') as Date</P> </PRE><P>I derived <SPAN style="font-size: 13.3333330154419px;">Quarter with the below code:</SPAN></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14297592081865187" jivemacro_uid="_14297592081865187"> <P>'Q' &amp; Ceil(Month(Date)/3) as Quarter,</P> </PRE><P></P><P>But I am getting Q1,Q2,Q3,Q4,Q.</P><P>I don't want Q. How to elimate this?</P><P>Why it is showing Q even I don't have any blank rows in excel file?</P></BODY></HTML> Thu, 23 Apr 2015 03:22:02 GMT qlikviewwizard 2015-04-23T03:22:02Z Deriving Quarter from date https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888063#M1011524 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have Date data in excel file in <SPAN style="font-size: 13.3333330154419px;">YYYYMMDD format.</SPAN></P><P>Used this function to convert to date format - </P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14297592136631336" jivemacro_uid="_14297592136631336"> <P>Date#('20131230','YYYYMMDD') as Date</P> </PRE><P>I derived <SPAN style="font-size: 13.3333330154419px;">Quarter with the below code:</SPAN></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_14297592081865187" jivemacro_uid="_14297592081865187"> <P>'Q' &amp; Ceil(Month(Date)/3) as Quarter,</P> </PRE><P></P><P>But I am getting Q1,Q2,Q3,Q4,Q.</P><P>I don't want Q. How to elimate this?</P><P>Why it is showing Q even I don't have any blank rows in excel file?</P></BODY></HTML> Thu, 23 Apr 2015 03:22:02 GMT https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888063#M1011524 qlikviewwizard 2015-04-23T03:22:02Z Re: Deriving Quarter from date https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888064#M1011525 <HTML><HEAD></HEAD><BODY><P>hi try like this</P><P>date(Date#('<SPAN style="color: #0000ff; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;">20131230'</SPAN>,'YYYYMMDD'),'DD/MM/YYYY') as date,</P><P><SPAN class="string" style="font-style: inherit; font-weight: inherit; line-height: 1.5em; color: blue; font-size: 9pt !important;">'Q'</SPAN><SPAN style="color: black; font-style: inherit; font-weight: inherit; line-height: 1.5em; font-size: 9pt !important;"> &amp; Ceil(</SPAN><SPAN class="func" style="font-style: inherit; font-weight: inherit; line-height: 1.5em; color: #ff1493; font-size: 9pt !important;">Month</SPAN><SPAN style="color: black; font-style: inherit; font-weight: inherit; line-height: 1.5em; font-size: 9pt !important;">(</SPAN><SPAN class="keyword" style="font-style: inherit; font-weight: inherit; line-height: 1.5em; color: #006699; font-size: 9pt !important;">Date</SPAN><SPAN style="color: black; font-style: inherit; font-weight: inherit; line-height: 1.5em; font-size: 9pt !important;">)/3) </SPAN><SPAN class="keyword" style="font-style: inherit; font-weight: inherit; line-height: 1.5em; color: #006699; font-size: 9pt !important;">as</SPAN><SPAN style="color: black; font-style: inherit; font-weight: inherit; line-height: 1.5em; font-size: 9pt !important;"> Quarter</SPAN></P></BODY></HTML> Thu, 23 Apr 2015 03:35:03 GMT https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888064#M1011525 arulsettu 2015-04-23T03:35:03Z Re: Deriving Quarter from date https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888065#M1011526 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/arulsettu">arulsettu</A></STRONG>, Tried. But not working.</P></BODY></HTML> Thu, 23 Apr 2015 03:49:39 GMT https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888065#M1011526 qlikviewwizard 2015-04-23T03:49:39Z Re: Deriving Quarter from date https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888066#M1011527 <HTML><HEAD></HEAD><BODY><P>can u post your qvw</P></BODY></HTML> Thu, 23 Apr 2015 03:50:28 GMT https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888066#M1011527 arulsettu 2015-04-23T03:50:28Z Re: Deriving Quarter from date https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888067#M1011528 <HTML><HEAD></HEAD><BODY><P>Maybe you don't have proper date. Can you post your excel file</P></BODY></HTML> Thu, 23 Apr 2015 05:01:14 GMT https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888067#M1011528 anbu1984 2015-04-23T05:01:14Z Re: Deriving Quarter from date https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888068#M1011529 <HTML><HEAD></HEAD><BODY><P>This is the data:</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="755"><TBODY><TR><TD class="xl66" height="20" width="97">EMPNO</TD><TD class="xl66" style="border-left: none;" width="73">ENAME</TD><TD class="xl66" style="border-left: none;" width="106">JOB</TD><TD class="xl66" style="border-left: none;" width="66">MGR</TD><TD class="xl67" style="border-left: none;" width="67">HIREDATE</TD><TD class="xl66" style="border-left: none;" width="37">SAL</TD><TD class="xl66" style="border-left: none;" width="49">COMM</TD><TD class="xl66" style="border-left: none;" width="58">DEPTNO</TD><TD class="xl67" style="border-left: none;" width="84">LASTDATE</TD><TD class="xl67" style="border-left: none;" width="118">MODIFYDATE</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo1</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME1</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo11</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19830112</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1100</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150302</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140101</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo2</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME2</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810220</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1600</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150303</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140202</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo3</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME3</TD><TD class="xl63" style="border-top: none; border-left: none;">MANAGER</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME8</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810501</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2850</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140303</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo4</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME4</TD><TD class="xl63" style="border-top: none; border-left: none;">MANAGER</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME8</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810609</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2450</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140404</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo5</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME5</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME7</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19811203</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3000</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150306</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140505</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo6</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME6</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19811203</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">950</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150307</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140606</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo7</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME7</TD><TD class="xl63" style="border-top: none; border-left: none;">MANAGER</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME8</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810402</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">2975</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140707</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo8</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME8</TD><TD class="xl63" style="border-top: none; border-left: none;">PRESIDENT</TD><TD class="xl63" style="border-top: none; border-left: none;">NULL</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19811117</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">5000</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140808</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo9</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME9</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810928</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1400</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150310</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140909</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo10</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME10</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo4</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19820123</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1300</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150311</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141010</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo11</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME11</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME7</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19821209</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">3000</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141111</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141111</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo12</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME12</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;">NULL</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150313</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141212</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo13</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME13</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150314</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140113</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo14</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME14</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150315</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140214</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo15</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME15</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140315</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo16</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME16</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo6</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150317</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140416</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo17</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME17</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME8</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140517</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140517</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo18</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME18</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150319</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140618</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo19</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME19</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150320</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140719</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo20</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME20</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150321</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140820</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo21</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME21</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo7</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150322</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140921</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo22</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME22</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo8</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150323</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141022</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo23</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME23</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME9</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1400</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150324</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141123</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo24</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME24</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141224</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo25</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME25</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150303</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140125</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo26</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME26</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">50</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150304</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140226</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo27</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME27</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo9</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150305</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140327</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo28</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME28</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150306</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140428</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo29</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME29</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150307</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140501</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo30</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME30</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150308</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140602</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo31</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME31</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150309</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140703</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo32</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME32</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150310</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140804</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo33</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME33</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo11</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140905</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo34</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME34</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150312</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141006</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo35</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME35</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME11</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150313</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141107</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo36</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME36</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150314</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141208</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo37</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME37</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1400</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150315</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140109</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo38</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME38</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150316</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140210</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo39</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME39</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo13</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140311</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo40</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME40</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo14</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">50</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150318</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140412</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo41</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME41</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME12</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140513</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140513</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo42</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME42</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140614</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140614</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo43</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME43</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150321</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140715</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo44</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME44</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150322</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140816</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo45</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME45</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo15</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150323</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20140917</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo46</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME46</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo16</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141018</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141018</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo47</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME47</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME13</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141119</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo48</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME48</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150303</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141220</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo49</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME49</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150304</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141121</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo50</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME50</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150305</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20141222</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo51</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME51</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo17</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1400</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150123</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo52</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME52</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo18</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150224</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo53</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME53</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME14</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150308</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150325</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo54</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME54</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">50</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150309</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150426</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo55</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME55</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150310</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150527</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo56</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME56</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150311</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150628</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo57</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME57</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo19</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150312</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150701</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo58</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME58</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150313</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150802</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo59</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME59</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME15</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150314</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150903</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo60</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME60</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151004</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151004</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo61</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME61</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150316</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151105</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo62</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME62</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150317</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151206</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo63</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME63</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo21</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150318</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150107</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo64</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME64</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo22</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150319</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150208</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo65</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME65</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME16</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1400</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150320</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150309</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo66</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME66</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150321</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150410</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo67</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME67</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150322</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150511</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo68</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME68</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">50</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150323</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150612</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo69</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME69</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo23</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150713</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo70</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME70</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo24</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150302</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150814</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo71</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME71</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME17</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150303</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150915</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo72</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME72</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150304</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151016</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo73</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME73</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150305</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151117</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo74</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME74</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150306</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151218</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo75</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME75</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo25</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150307</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150119</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo76</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME76</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo26</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD class="xl64" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150220</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo77</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME77</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME18</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150309</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150321</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo78</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME78</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150310</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150422</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo79</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME79</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1400</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150311</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150523</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo80</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME80</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150312</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150624</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo81</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME81</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo27</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150313</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150725</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo82</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME82</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo28</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">50</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150314</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150826</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo83</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME83</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME19</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150315</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150927</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo84</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME84</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150316</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151028</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo85</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME85</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151101</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151101</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo86</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME86</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151202</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151202</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo87</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME87</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo29</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150319</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150103</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo88</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME88</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150320</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150204</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo89</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME89</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150321</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150305</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo90</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME90</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150322</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150406</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo91</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME91</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150323</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150507</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo92</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME92</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150317</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150608</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo93</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME93</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo31</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1400</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150318</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150709</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo94</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME94</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo32</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">10</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150319</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150810</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo95</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME95</TD><TD class="xl63" style="border-top: none; border-left: none;">ANALYST</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME21</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD class="xl63" style="border-top: none; border-left: none;"> </TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150320</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150911</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo96</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME96</TD><TD class="xl63" style="border-top: none; border-left: none;">CLERK</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo5</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">50</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150321</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151012</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo97</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME97</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810908</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">800</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150322</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151113</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo98</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME98</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo3</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19810222</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">500</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">30</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150323</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151214</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo99</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME99</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo33</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1400</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150317</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151115</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">EMPNo100</TD><TD class="xl63" style="border-top: none; border-left: none;">ENAME100</TD><TD class="xl63" style="border-top: none; border-left: none;">SALESMAN</TD><TD class="xl63" style="border-top: none; border-left: none;">EMPNo33</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">19801217</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1250</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1400</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">20</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20150317</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">20151216</TD></TR></TBODY></TABLE></BODY></HTML> Thu, 23 Apr 2015 05:10:12 GMT https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888068#M1011529 qlikviewwizard 2015-04-23T05:10:12Z Re: Deriving Quarter from date https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888069#M1011530 <HTML><HEAD></HEAD><BODY><P>check this</P></BODY></HTML> Thu, 23 Apr 2015 05:18:11 GMT https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888069#M1011530 arulsettu 2015-04-23T05:18:11Z Re: Deriving Quarter from date https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888070#M1011531 <HTML><HEAD></HEAD><BODY><P>You have blanks in Last date</P></BODY></HTML> Thu, 23 Apr 2015 05:29:29 GMT https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888070#M1011531 anbu1984 2015-04-23T05:29:29Z Re: Deriving Quarter from date https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888071#M1011532 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You have some Null values in LastDate date column so use this expression</P><P></P><OL class="dp-sql" start="1" style="font-size: 12px; font-family: Consolas, 'Courier New', Courier, mono, serif; color: #5c5c5c; margin: 0 0 1px 45px !important;"><LI><SPAN style="font-weight: inherit; font-style: inherit; color: black; font-size: 9pt !important; background-color: inherit;"><SPAN class="string" style="font-weight: inherit; font-style: inherit; color: blue; font-size: 9pt !important; background-color: inherit;">If(Len(Trim(<SPAN style="color: #006699; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;">Date)) &gt; 0, </SPAN>'Q'</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"> &amp; Ceil(</SPAN><SPAN class="func" style="font-weight: inherit; font-style: inherit; color: #ff1493; font-size: 9pt !important; background-color: inherit;">Month</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;">(</SPAN><SPAN class="keyword" style="font-weight: inherit; font-style: inherit; color: #006699; font-size: 9pt !important; background-color: inherit;">Date</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;">)/3)) </SPAN><SPAN class="keyword" style="font-weight: inherit; font-style: inherit; color: #006699; font-size: 9pt !important; background-color: inherit;">as</SPAN><SPAN style="font-weight: inherit; font-style: inherit; font-size: 9pt !important; background-color: inherit;"> Quarter,&nbsp; </SPAN></SPAN></LI><LI><SPAN style="color: black; font-size: 9pt !important; font-style: inherit; background-color: inherit; font-weight: inherit;"><BR /></SPAN></LI></OL><P><SPAN style="color: black; font-size: 9pt !important; font-style: inherit; background-color: inherit; font-weight: inherit;">Hope this helps you.</SPAN></P><P><SPAN style="color: black; font-size: 9pt !important; font-style: inherit; background-color: inherit; font-weight: inherit;"><BR /></SPAN></P><P><SPAN style="color: black; font-size: 9pt !important; font-style: inherit; background-color: inherit; font-weight: inherit;">Regards,</SPAN></P><P><SPAN style="color: black; font-size: 9pt !important; font-style: inherit; background-color: inherit; font-weight: inherit;">jagan.<BR /></SPAN></P></BODY></HTML> Thu, 23 Apr 2015 06:10:40 GMT https://community.qlik.com/t5/QlikView/Deriving-Quarter-from-date/m-p/888071#M1011532 jagan 2015-04-23T06:10:40Z