topic Re: Another Accumulation problem in QlikView https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063051#M941620 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>TEMP:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>&nbsp; Year(TEMP_DATE) as YEAR</STRONG></P><P><STRONG>INLINE [</STRONG></P><P><STRONG>TEMP_DATE, EMP_ID, LEAVES, ACCUMULATION</STRONG></P><P><STRONG>1/1/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/2/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/3/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/4/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/5/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/6/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/7/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/8/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/9/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/10/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/11/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/12/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/13/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/14/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/15/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/16/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/17/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/18/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/19/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/20/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/21/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/22/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/23/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/24/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/25/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/26/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/27/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/28/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/29/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/30/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/31/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/1/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/2/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/3/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/4/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/5/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/6/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/7/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/8/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/9/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/10/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/11/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/12/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/13/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/14/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/15/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/16/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/17/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/18/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/19/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/20/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/21/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/22/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/23/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/24/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/25/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/26/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/27/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/28/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/1/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/2/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/3/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/4/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/5/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/6/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/7/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/8/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/9/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/10/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/11/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/12/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/13/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/14/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/15/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/16/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/17/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/18/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/19/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/20/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/21/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/22/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/23/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/24/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/25/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/26/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/27/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/28/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/29/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/30/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/31/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/1/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/2/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/3/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/4/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/5/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/6/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/7/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/8/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/9/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/10/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/11/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/12/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/13/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/14/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/15/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/16/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/17/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/18/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/19/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/20/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/21/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/22/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/23/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/24/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/25/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/26/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/27/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/28/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/29/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/30/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/1/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/2/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/3/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/4/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/5/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/6/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/7/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/8/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/9/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/10/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/11/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/12/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/13/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/14/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/15/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/16/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/17/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/18/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/19/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/20/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/21/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/22/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/23/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/24/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/25/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/26/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/27/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/28/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/29/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/30/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/31/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/1/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/2/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/3/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/4/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/5/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/6/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/7/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/8/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/9/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/10/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/11/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/12/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/13/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/14/2014, 1234, 1, 13</STRONG></P><P><STRONG>6/15/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/16/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/17/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/18/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/19/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/20/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/21/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/22/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/23/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/24/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/25/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/26/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/27/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/28/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/29/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/31/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/31/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/31/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/31/2014, 1234, 0, 28</STRONG></P><P><STRONG>1/1/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/2/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/3/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/4/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/5/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/6/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/7/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/8/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/9/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/10/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/11/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/12/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/13/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/14/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/15/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/16/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/17/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/18/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/19/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/20/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/21/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/22/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/23/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/24/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/25/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/26/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/27/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/28/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/29/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/30/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/31/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/1/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/2/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/3/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/4/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/5/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/6/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/7/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/8/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/9/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/10/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/11/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/12/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/13/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/14/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/15/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/16/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/17/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/18/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/19/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/20/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/21/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/22/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/23/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/24/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/25/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/26/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/27/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/28/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/1/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/2/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/3/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/4/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/5/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/6/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/7/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/8/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/9/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/10/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/11/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/12/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/13/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/14/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/15/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/16/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/17/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/18/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/19/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/20/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/21/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/22/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/23/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/24/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/25/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/26/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/27/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/28/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/29/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/30/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/31/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/1/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/2/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/3/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/4/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/5/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/6/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/7/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/8/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/9/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/10/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/11/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/12/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/13/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/14/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/15/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/16/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/17/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/18/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/19/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/20/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/21/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/22/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/23/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/24/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/25/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/26/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/27/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/28/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/29/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/30/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/1/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/2/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/3/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/4/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/5/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/6/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/7/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/8/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/9/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/10/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/11/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/12/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/13/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/14/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/15/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/16/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/17/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/18/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/19/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/20/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/21/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/22/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/23/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/24/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/25/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/26/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/27/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/28/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/29/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/30/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/31/2015, 1234, 0, 30</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>Final:</STRONG></P><P><STRONG>LOAD TEMP_DATE,</STRONG></P><P><STRONG>&nbsp; EMP_ID,</STRONG></P><P><STRONG>&nbsp; LEAVES,</STRONG></P><P><STRONG>&nbsp; YEAR,</STRONG></P><P><STRONG>&nbsp; If(EMP_ID = Peek('EMP_ID') and YEAR = Peek('YEAR'),</STRONG></P><P><STRONG>&nbsp; If(LEAVES = 0,</STRONG></P><P><STRONG>&nbsp; RangeSum(Peek('SCRIPT_ACCU'), LEAVES), </STRONG></P><P><STRONG>&nbsp; If(LEAVES = PEEK('LEAVES'),</STRONG></P><P><STRONG>&nbsp; RangeSum(Peek('SCRIPT_ACCU'), 0),</STRONG></P><P><STRONG>&nbsp; RangeSum(Peek('SCRIPT_ACCU'), LEAVES))), LEAVES) AS SCRIPT_ACCU,</STRONG></P><P><STRONG>&nbsp; ACCUMULATION</STRONG></P><P><STRONG>Resident TEMP</STRONG></P><P><STRONG>Order By EMP_ID, TEMP_DATE;</STRONG></P><P></P><P><STRONG>DROP Table TEMP;</STRONG></P></BODY></HTML> Mon, 25 Jan 2016 01:54:59 GMT sunny_talwar 2016-01-25T01:54:59Z Another Accumulation problem https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063047#M941616 <HTML><HEAD></HEAD><BODY><P>‌Hi wonderful qlik experts,</P><P></P><P>what i have:</P><P></P><P>1. all the calendar dates</P><P>2. all the employee numbers which are active</P><P>2. no of leaves taken on relevant date. for example if a person has taken a leave for 5 days from 1 april 2014 to 5 april 2014, then for all these dates there will be 5 against it.</P><P></P><P>what i want to achieve:</P><P></P><P>the accumulated value for all the leaves as shown in the pictures attached.</P><P>there is one more addition to the accumulation that when the new year starts, it should start accumulation for that year</P><P>for example, if the accumulated value is 35 till 31 dec, 2014 then it should start accumulating again from 1 jan, 2015 and not add the value from the last year.</P><P></P><P>Best regards,</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063047#M941616 gaurav2017 2020-11-20T18:02:30Z Re: Another Accumulation problem https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063048#M941617 <HTML><HEAD></HEAD><BODY><P>Do you have a sample data you can share? Would be easier to help you with some sample data.</P></BODY></HTML> Sun, 24 Jan 2016 20:55:19 GMT https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063048#M941617 sunny_talwar 2016-01-24T20:55:19Z Re: Another Accumulation problem https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063049#M941618 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Try like this,</P><P></P><P><STRONG><EM style="text-decoration: underline;">Expression:</EM></STRONG></P><P><STRONG style="font-size: 10pt; line-height: 1.5em;"><BR /></STRONG></P><P><STRONG style="font-size: 10pt; line-height: 1.5em;">RangeSum(Above(Sum(Leaves), 0, (RowNo(TOTAL) - (Year - Min(TOTAL Year))* 12)))</STRONG></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Keep no accumulation for expression.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">else,</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Post sample app.<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">HTH,</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Hirish<BR /></SPAN></P></BODY></HTML> Sun, 24 Jan 2016 21:38:45 GMT https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063049#M941618 HirisH_V7 2016-01-24T21:38:45Z Re: Another Accumulation problem https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063050#M941619 <HTML><HEAD></HEAD><BODY><P>‌sample data attached in the inline format</P></BODY></HTML> Mon, 25 Jan 2016 00:29:51 GMT https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063050#M941619 gaurav2017 2016-01-25T00:29:51Z Re: Another Accumulation problem https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063051#M941620 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>TEMP:</STRONG></P><P><STRONG>LOAD *,</STRONG></P><P><STRONG>&nbsp; Year(TEMP_DATE) as YEAR</STRONG></P><P><STRONG>INLINE [</STRONG></P><P><STRONG>TEMP_DATE, EMP_ID, LEAVES, ACCUMULATION</STRONG></P><P><STRONG>1/1/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/2/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/3/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/4/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/5/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/6/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/7/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/8/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/9/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/10/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/11/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/12/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/13/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/14/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/15/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/16/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/17/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/18/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/19/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/20/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/21/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/22/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/23/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/24/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/25/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/26/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/27/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/28/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/29/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/30/2014, 1234, 0, 0</STRONG></P><P><STRONG>1/31/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/1/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/2/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/3/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/4/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/5/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/6/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/7/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/8/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/9/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/10/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/11/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/12/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/13/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/14/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/15/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/16/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/17/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/18/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/19/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/20/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/21/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/22/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/23/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/24/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/25/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/26/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/27/2014, 1234, 0, 0</STRONG></P><P><STRONG>2/28/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/1/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/2/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/3/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/4/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/5/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/6/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/7/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/8/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/9/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/10/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/11/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/12/2014, 1234, 0, 0</STRONG></P><P><STRONG>3/13/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/14/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/15/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/16/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/17/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/18/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/19/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/20/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/21/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/22/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/23/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/24/2014, 1234, 12, 12</STRONG></P><P><STRONG>3/25/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/26/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/27/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/28/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/29/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/30/2014, 1234, 0, 12</STRONG></P><P><STRONG>3/31/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/1/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/2/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/3/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/4/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/5/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/6/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/7/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/8/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/9/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/10/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/11/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/12/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/13/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/14/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/15/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/16/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/17/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/18/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/19/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/20/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/21/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/22/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/23/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/24/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/25/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/26/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/27/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/28/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/29/2014, 1234, 0, 12</STRONG></P><P><STRONG>4/30/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/1/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/2/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/3/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/4/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/5/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/6/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/7/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/8/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/9/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/10/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/11/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/12/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/13/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/14/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/15/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/16/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/17/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/18/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/19/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/20/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/21/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/22/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/23/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/24/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/25/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/26/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/27/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/28/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/29/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/30/2014, 1234, 0, 12</STRONG></P><P><STRONG>5/31/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/1/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/2/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/3/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/4/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/5/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/6/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/7/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/8/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/9/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/10/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/11/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/12/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/13/2014, 1234, 0, 12</STRONG></P><P><STRONG>6/14/2014, 1234, 1, 13</STRONG></P><P><STRONG>6/15/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/16/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/17/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/18/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/19/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/20/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/21/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/22/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/23/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/24/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/25/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/26/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/27/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/28/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/29/2014, 1234, 15, 28</STRONG></P><P><STRONG>6/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>7/31/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>8/31/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>9/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>10/31/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>11/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/1/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/2/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/3/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/4/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/5/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/6/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/7/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/8/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/9/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/10/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/11/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/12/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/13/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/14/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/15/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/16/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/17/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/18/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/19/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/20/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/21/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/22/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/23/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/24/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/25/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/26/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/27/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/28/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/29/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/30/2014, 1234, 0, 28</STRONG></P><P><STRONG>12/31/2014, 1234, 0, 28</STRONG></P><P><STRONG>1/1/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/2/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/3/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/4/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/5/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/6/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/7/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/8/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/9/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/10/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/11/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/12/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/13/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/14/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/15/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/16/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/17/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/18/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/19/2015, 1234, 0, 0</STRONG></P><P><STRONG>1/20/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/21/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/22/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/23/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/24/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/25/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/26/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/27/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/28/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/29/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/30/2015, 1234, 30, 30</STRONG></P><P><STRONG>1/31/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/1/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/2/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/3/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/4/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/5/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/6/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/7/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/8/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/9/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/10/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/11/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/12/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/13/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/14/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/15/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/16/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/17/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/18/2015, 1234, 30, 30</STRONG></P><P><STRONG>2/19/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/20/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/21/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/22/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/23/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/24/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/25/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/26/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/27/2015, 1234, 0, 30</STRONG></P><P><STRONG>2/28/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/1/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/2/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/3/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/4/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/5/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/6/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/7/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/8/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/9/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/10/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/11/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/12/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/13/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/14/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/15/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/16/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/17/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/18/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/19/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/20/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/21/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/22/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/23/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/24/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/25/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/26/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/27/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/28/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/29/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/30/2015, 1234, 0, 30</STRONG></P><P><STRONG>3/31/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/1/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/2/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/3/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/4/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/5/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/6/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/7/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/8/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/9/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/10/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/11/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/12/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/13/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/14/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/15/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/16/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/17/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/18/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/19/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/20/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/21/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/22/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/23/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/24/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/25/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/26/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/27/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/28/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/29/2015, 1234, 0, 30</STRONG></P><P><STRONG>4/30/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/1/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/2/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/3/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/4/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/5/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/6/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/7/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/8/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/9/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/10/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/11/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/12/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/13/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/14/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/15/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/16/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/17/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/18/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/19/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/20/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/21/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/22/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/23/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/24/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/25/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/26/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/27/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/28/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/29/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/30/2015, 1234, 0, 30</STRONG></P><P><STRONG>5/31/2015, 1234, 0, 30</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>Final:</STRONG></P><P><STRONG>LOAD TEMP_DATE,</STRONG></P><P><STRONG>&nbsp; EMP_ID,</STRONG></P><P><STRONG>&nbsp; LEAVES,</STRONG></P><P><STRONG>&nbsp; YEAR,</STRONG></P><P><STRONG>&nbsp; If(EMP_ID = Peek('EMP_ID') and YEAR = Peek('YEAR'),</STRONG></P><P><STRONG>&nbsp; If(LEAVES = 0,</STRONG></P><P><STRONG>&nbsp; RangeSum(Peek('SCRIPT_ACCU'), LEAVES), </STRONG></P><P><STRONG>&nbsp; If(LEAVES = PEEK('LEAVES'),</STRONG></P><P><STRONG>&nbsp; RangeSum(Peek('SCRIPT_ACCU'), 0),</STRONG></P><P><STRONG>&nbsp; RangeSum(Peek('SCRIPT_ACCU'), LEAVES))), LEAVES) AS SCRIPT_ACCU,</STRONG></P><P><STRONG>&nbsp; ACCUMULATION</STRONG></P><P><STRONG>Resident TEMP</STRONG></P><P><STRONG>Order By EMP_ID, TEMP_DATE;</STRONG></P><P></P><P><STRONG>DROP Table TEMP;</STRONG></P></BODY></HTML> Mon, 25 Jan 2016 01:54:59 GMT https://community.qlik.com/t5/QlikView/Another-Accumulation-problem/m-p/1063051#M941620 sunny_talwar 2016-01-25T01:54:59Z