topic Re: populating values in QlikView

topic Re: populating values in QlikView https://community.qlik.com/t5/QlikView/populating-values/m-p/996736#M955514 <HTML><HEAD></HEAD><BODY><P>This is one solution in the script, but this requires order by statement:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD year, </STRONG></P><P><STRONG>    month, </STRONG></P><P><STRONG>    price</STRONG></P><P><STRONG>//    avgprice,</STRONG></P><P><STRONG>//    neutalprice, </STRONG></P><P><STRONG>//    midstockprice</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2003" data-containertype="14" data-objectid="191475" data-objecttype="1" href="https://community.qlik.com/thread/191475">https://community.qlik.com/thread/191475</A><SPAN>]</SPAN></STRONG></P><P><STRONG>(html, codepage is 1252, embedded labels, table is @1);</STRONG></P><P></P><P><STRONG>NewTable:</STRONG></P><P><STRONG>NoConcatenate</STRONG></P><P><STRONG>LOAD year as Year,</STRONG></P><P><STRONG>    month as Month,</STRONG></P><P><STRONG>    price as Price,</STRONG></P><P><STRONG>//    [average Price] as [Average Price],</STRONG></P><P><STRONG>    If(month <= 12,</STRONG></P><P><STRONG>    If(Peek('Year', -12) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7), Peek('Price', -8),</STRONG></P><P><STRONG>      Peek('Price', -9), Peek('Price', -10), Peek('Price', -11), Peek('Price', -12)),</STRONG></P><P><STRONG>    If(Peek('Year', -11) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7), Peek('Price', -8),</STRONG></P><P><STRONG>      Peek('Price', -9), Peek('Price', -10), Peek('Price', -11)),</STRONG></P><P><STRONG>    If(Peek('Year', -10) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7), Peek('Price', -8),</STRONG></P><P><STRONG>      Peek('Price', -9), Peek('Price', -10)),</STRONG></P><P><STRONG>    If(Peek('Year', -9) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7), Peek('Price', -8),</STRONG></P><P><STRONG>      Peek('Price', -9)),</STRONG></P><P><STRONG>    If(Peek('Year', -8) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7), Peek('Price', -8)),</STRONG></P><P><STRONG>    If(Peek('Year', -7) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7)),</STRONG></P><P><STRONG>    If(Peek('Year', -6) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6)),</STRONG></P><P><STRONG>    If(Peek('Year', -5) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5)),</STRONG></P><P><STRONG>    If(Peek('Year', -4) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4)),</STRONG></P><P><STRONG>    If(Peek('Year', -3) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3)),</STRONG></P><P><STRONG>    If(Peek('Year', -2) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2)),</STRONG></P><P><STRONG>    If(Peek('Year', -1) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1)), price)))))))))))),</STRONG></P><P><STRONG>    Peek('Average Price')) as [Average Price]</STRONG></P><P><STRONG>Resident Table</STRONG></P><P><STRONG>Order By year, month;</STRONG></P><P></P><P><STRONG>DROP Table Table;</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105505_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Sat, 14 Nov 2015 13:25:04 GMT sunny_talwar 2015-11-14T13:25:04Z populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996731#M955509 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>This is my scenario. Please suggest.</P><P></P><P>basically avgprice is getting calculated by front end expression.. now after 12th month.. 13th to 18th month it should populate the same avgprice as 12 th month until 18th..</P><P></P><P>secondly these avgprice values should also gets populated from the 12th month avgprice for neutalprice and midstockprice from 13 to 18th</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" width="462"><TBODY><TR><TD height="19" style="border: 0px black; border-image: none;" width="64"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">year</STRONG></TD><TD style="border: 0px black; border-image: none;" width="64"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">month</STRONG></TD><TD style="border: 0px black; border-image: none;" width="64"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">price</STRONG></TD><TD style="border: 0px black; border-image: none;" width="88"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">avgprice</STRONG></TD><TD style="border: 0px black; border-image: none;" width="92"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">neutalprice</STRONG></TD><TD style="border: 0px black; border-image: none;" width="90"><STRONG style="color: #000000; font-size: 12pt; font-family: Calibri;">midstockprice</STRONG></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">18</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">33</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">17</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">33</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">16</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">33</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">15</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">33</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">14</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">33</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">13</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">33</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px red; border-image: none;"><SPAN style="color: #ff0000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">12</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">33</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">23,91666667</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">23,91666667</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-size: 12pt; font-family: Calibri;">23,91666667</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">11</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">31</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">23,09090909</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">22</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">77</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">10</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">22</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">22,3</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">34</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">6</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">9</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">34</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">22,33333333</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">22</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">5</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">8</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">11</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">20,875</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">33</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">7</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">44</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">22,28571429</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">11</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">5</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">6</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">77</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">18,66666667</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">44</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">6</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">5</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">6</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">7</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">77</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">7</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">5</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">7,25</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">88</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">88</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">3</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">7</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">8</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">99</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">7</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">8</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">8,5</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">44</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">65</SPAN></TD></TR><TR><TD align="right" height="19" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">2015</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">1</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">9</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">9</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">3</SPAN></TD><TD align="right" style="border: 0px black; border-image: none;"><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">4</SPAN></TD></TR></TBODY></TABLE><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">  </SPAN></P></BODY></HTML> Sat, 14 Nov 2015 12:38:06 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996731#M955509 raadwiptec 2015-11-14T12:38:06Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996732#M955510 <HTML><HEAD></HEAD><BODY><P>You were going to send me this in an email or something bigger? Front end solution would work?</P></BODY></HTML> Sat, 14 Nov 2015 12:52:24 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996732#M955510 sunny_talwar 2015-11-14T12:52:24Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996733#M955511 <HTML><HEAD></HEAD><BODY><P>hi sunny yes I am trying to cover this on the script..probably a bigger note.to your email. but in the mean time can u suggest here as well</P></BODY></HTML> Sat, 14 Nov 2015 12:55:59 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996733#M955511 raadwiptec 2015-11-14T12:55:59Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996734#M955512 <HTML><HEAD></HEAD><BODY><P>I cannot send you a message until you follow me, so either follow me or send me IM since I have already followed you</P></BODY></HTML> Sat, 14 Nov 2015 13:10:12 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996734#M955512 sunny_talwar 2015-11-14T13:10:12Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996735#M955513 <HTML><HEAD></HEAD><BODY><P>hi sunny iam trying to find the option to send you a message ..I don't find anywhere in the website</P></BODY></HTML> Sat, 14 Nov 2015 13:14:53 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996735#M955513 raadwiptec 2015-11-14T13:14:53Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996736#M955514 <HTML><HEAD></HEAD><BODY><P>This is one solution in the script, but this requires order by statement:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD year, </STRONG></P><P><STRONG>    month, </STRONG></P><P><STRONG>    price</STRONG></P><P><STRONG>//    avgprice,</STRONG></P><P><STRONG>//    neutalprice, </STRONG></P><P><STRONG>//    midstockprice</STRONG></P><P><STRONG>FROM</STRONG></P><P><STRONG><SPAN>[</SPAN><A class="jive-link-thread-small" data-containerid="2003" data-containertype="14" data-objectid="191475" data-objecttype="1" href="https://community.qlik.com/thread/191475">https://community.qlik.com/thread/191475</A><SPAN>]</SPAN></STRONG></P><P><STRONG>(html, codepage is 1252, embedded labels, table is @1);</STRONG></P><P></P><P><STRONG>NewTable:</STRONG></P><P><STRONG>NoConcatenate</STRONG></P><P><STRONG>LOAD year as Year,</STRONG></P><P><STRONG>    month as Month,</STRONG></P><P><STRONG>    price as Price,</STRONG></P><P><STRONG>//    [average Price] as [Average Price],</STRONG></P><P><STRONG>    If(month <= 12,</STRONG></P><P><STRONG>    If(Peek('Year', -12) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7), Peek('Price', -8),</STRONG></P><P><STRONG>      Peek('Price', -9), Peek('Price', -10), Peek('Price', -11), Peek('Price', -12)),</STRONG></P><P><STRONG>    If(Peek('Year', -11) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7), Peek('Price', -8),</STRONG></P><P><STRONG>      Peek('Price', -9), Peek('Price', -10), Peek('Price', -11)),</STRONG></P><P><STRONG>    If(Peek('Year', -10) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7), Peek('Price', -8),</STRONG></P><P><STRONG>      Peek('Price', -9), Peek('Price', -10)),</STRONG></P><P><STRONG>    If(Peek('Year', -9) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7), Peek('Price', -8),</STRONG></P><P><STRONG>      Peek('Price', -9)),</STRONG></P><P><STRONG>    If(Peek('Year', -8) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7), Peek('Price', -8)),</STRONG></P><P><STRONG>    If(Peek('Year', -7) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6), Peek('Price', -7)),</STRONG></P><P><STRONG>    If(Peek('Year', -6) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5), Peek('Price', -6)),</STRONG></P><P><STRONG>    If(Peek('Year', -5) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4),</STRONG></P><P><STRONG>      Peek('Price', -5)),</STRONG></P><P><STRONG>    If(Peek('Year', -4) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3), Peek('Price', -4)),</STRONG></P><P><STRONG>    If(Peek('Year', -3) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2), Peek('Price', -3)),</STRONG></P><P><STRONG>    If(Peek('Year', -2) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1), Peek('Price', -2)),</STRONG></P><P><STRONG>    If(Peek('Year', -1) = year,</STRONG></P><P><STRONG>    RangeAvg(price, Peek('Price', -1)), price)))))))))))),</STRONG></P><P><STRONG>    Peek('Average Price')) as [Average Price]</STRONG></P><P><STRONG>Resident Table</STRONG></P><P><STRONG>Order By year, month;</STRONG></P><P></P><P><STRONG>DROP Table Table;</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/105505_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Sat, 14 Nov 2015 13:25:04 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996736#M955514 sunny_talwar 2015-11-14T13:25:04Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996737#M955515 <HTML><HEAD></HEAD><BODY><P>hi sunny , I have added u as connection and following you. but not able to send you  a message. if I try to send a message to you..it does not allow me ..anything am I missing here?</P></BODY></HTML> Sat, 14 Nov 2015 13:29:52 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996737#M955515 raadwiptec 2015-11-14T13:29:52Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996738#M955516 <HTML><HEAD></HEAD><BODY><P>No you are doing it right. I added my email to this post and you should have got it in your email. Can you see it?</P></BODY></HTML> Sat, 14 Nov 2015 13:31:21 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996738#M955516 sunny_talwar 2015-11-14T13:31:21Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996739#M955517 <HTML><HEAD></HEAD><BODY><P>I just received this email as Sunny T approved you as a connection</P><P>but I do not find any other info..ur email id etc.. even the qlikview inbox nothing exists</P></BODY></HTML> Sat, 14 Nov 2015 13:35:13 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996739#M955517 raadwiptec 2015-11-14T13:35:13Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996740#M955518 <HTML><HEAD></HEAD><BODY><P>Is their any front end solutions </P></BODY></HTML> Sat, 14 Nov 2015 17:00:41 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996740#M955518 raadwiptec 2015-11-14T17:00:41Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996741#M955519 <HTML><HEAD></HEAD><BODY><P>Here, look at this expression:</P><P></P><P><STRONG>=If([Month of Stock] <= 12, If(Sum([Price Value]) > 0, RangeAvg(Above(Sum({<[Month of Stock] = >}[Price Value]), 0, RowNo()))), Above([Avg Price Expression]))</STRONG></P><P></P><P>Here <STRONG>Avg Price Expression </STRONG>is the Expression Label and you need to change it to you expression label. It should turn blue when it matches your expression label.</P></BODY></HTML> Sat, 14 Nov 2015 17:39:49 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996741#M955519 sunny_talwar 2015-11-14T17:39:49Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996742#M955520 <HTML><HEAD></HEAD><BODY><P>Hi Sunny,</P><P></P><P>How can I include this expression value into my QVD?</P></BODY></HTML> Fri, 20 Nov 2015 12:22:56 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996742#M955520 raadwiptec 2015-11-20T12:22:56Z Re: populating values https://community.qlik.com/t5/QlikView/populating-values/m-p/996743#M955521 <HTML><HEAD></HEAD><BODY><P>‌there is a post reload Trigger + Macro which can help you achieve that. But I think if you want to save the results in a QVD it would be advisable to do it in the script itself. I don't advise to use Macro + Trigger as it is not a very efficient solution.</P></BODY></HTML> Fri, 20 Nov 2015 13:28:23 GMT https://community.qlik.com/t5/QlikView/populating-values/m-p/996743#M955521 sunny_talwar 2015-11-20T13:28:23Z