topic Re: Max 5 values in QlikView https://community.qlik.com/t5/QlikView/Max-5-values/m-p/1082438#M918574 <HTML><HEAD></HEAD><BODY><P>Temp:</P><P>Load * Inline [</P><P>Year</P><P>2007</P><P>2008</P><P>2010</P><P>2009</P><P>2011</P><P>2012</P><P>2013</P><P>2014</P><P>2015</P><P>2016</P><P>2017</P><P>] ;</P><P></P><P></P><P>Temp1:</P><P>Load *,</P><P>RecNo() as Record</P><P>Resident Temp</P><P>order by Year desc;</P><P></P><P></P><P>drop table Temp;</P><P></P><P></P><P>Final:</P><P>Load Year</P><P>where Record &lt; 6;</P><P>Load *</P><P>Resident Temp1;</P><P></P><P></P><P>Drop table Temp1;</P></BODY></HTML> Thu, 05 May 2016 16:25:09 GMT 2016-05-05T16:25:09Z Max 5 values https://community.qlik.com/t5/QlikView/Max-5-values/m-p/1082436#M918572 <HTML><HEAD></HEAD><BODY><P>Hi i have one field,in that i want max five .</P><P></P><P>Load * Inline [ </P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 64px;"><TBODY><TR><TD height="20" width="64">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year</TD></TR><TR><TD align="right" height="20">2007</TD></TR><TR><TD align="right" height="20">2008</TD></TR><TR><TD align="right" height="20">2009</TD></TR><TR><TD align="right" height="20">2010</TD></TR><TR><TD align="right" height="20">2011</TD></TR><TR><TD align="right" height="20">2012</TD></TR><TR><TD align="right" height="20">2013</TD></TR><TR><TD align="right" height="20">2014</TD></TR><TR><TD align="right" height="20">2015</TD></TR><TR><TD align="right" height="20">2016</TD></TR><TR><TD align="right" height="20">2017</TD></TR></TBODY></TABLE><P>] ;</P><P></P><P>Output :</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 64px;"><TBODY><TR><TD align="right" height="20">2013</TD></TR><TR><TD align="right" height="20">2014</TD></TR><TR><TD align="right" height="20">2015</TD></TR><TR><TD align="right" height="20">2016</TD></TR><TR><TD align="right" height="20">2017</TD></TR></TBODY></TABLE><P></P><P>If i enter to next year i.e 2018 my output should be </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 64px;"><TBODY><TR><TD align="right" height="20">2014</TD></TR><TR><TD align="right" height="20">2015</TD></TR><TR><TD align="right" height="20">2016</TD></TR><TR><TD align="right" height="20"><P>2017</P><P>2018</P></TD></TR></TBODY></TABLE><P>How to gyt this ?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Max-5-values/m-p/1082436#M918572 subbareddykm 2020-11-25T16:16:04Z Re: Max 5 values https://community.qlik.com/t5/QlikView/Max-5-values/m-p/1082437#M918573 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>Load * Inline [</STRONG></P><P><STRONG>Year</STRONG></P><P><STRONG>2007</STRONG></P><P><STRONG>2008</STRONG></P><P><STRONG>2009</STRONG></P><P><STRONG>2010</STRONG></P><P><STRONG>2011</STRONG></P><P><STRONG>2012</STRONG></P><P><STRONG>2013</STRONG></P><P><STRONG>2014</STRONG></P><P><STRONG>2015</STRONG></P><P><STRONG>2016</STRONG></P><P><STRONG>2017</STRONG></P><P><STRONG>];</STRONG></P><P></P><P><STRONG>Right Join</STRONG></P><P><STRONG>LOAD Max5 + IterNo() as Year</STRONG></P><P><STRONG>While Max5 + IterNo() &lt;= Max;</STRONG></P><P><STRONG>LOAD Max(Year) as Max,</STRONG></P><P><STRONG>&nbsp; Max(Year) -5 as Max5</STRONG></P><P><STRONG>Resident Table;</STRONG></P></BODY></HTML> Thu, 05 May 2016 16:08:13 GMT https://community.qlik.com/t5/QlikView/Max-5-values/m-p/1082437#M918573 sunny_talwar 2016-05-05T16:08:13Z Re: Max 5 values https://community.qlik.com/t5/QlikView/Max-5-values/m-p/1082438#M918574 <HTML><HEAD></HEAD><BODY><P>Temp:</P><P>Load * Inline [</P><P>Year</P><P>2007</P><P>2008</P><P>2010</P><P>2009</P><P>2011</P><P>2012</P><P>2013</P><P>2014</P><P>2015</P><P>2016</P><P>2017</P><P>] ;</P><P></P><P></P><P>Temp1:</P><P>Load *,</P><P>RecNo() as Record</P><P>Resident Temp</P><P>order by Year desc;</P><P></P><P></P><P>drop table Temp;</P><P></P><P></P><P>Final:</P><P>Load Year</P><P>where Record &lt; 6;</P><P>Load *</P><P>Resident Temp1;</P><P></P><P></P><P>Drop table Temp1;</P></BODY></HTML> Thu, 05 May 2016 16:25:09 GMT https://community.qlik.com/t5/QlikView/Max-5-values/m-p/1082438#M918574 2016-05-05T16:25:09Z Re: Max 5 values https://community.qlik.com/t5/QlikView/Max-5-values/m-p/1082439#M918575 <HTML><HEAD></HEAD><BODY><P>But my year should give all years&nbsp; and i want one more field with max five years with link to my year field</P></BODY></HTML> Wed, 11 May 2016 15:43:06 GMT https://community.qlik.com/t5/QlikView/Max-5-values/m-p/1082439#M918575 subbareddykm 2016-05-11T15:43:06Z