topic Records in QlikView https://community.qlik.com/t5/QlikView/Records/m-p/927337#M968092 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">i have one table like fields YEAR,PRODUCT,SALES .each field have 5 records. When i go for Relode&nbsp;&nbsp; i want&nbsp;&nbsp; last 3 records.</SPAN></P><P></P><P>How i will&nbsp; Get the&nbsp; Last 3 records ?</P></BODY></HTML> Wed, 23 Sep 2015 17:19:34 GMT qlikview979 2015-09-23T17:19:34Z Records https://community.qlik.com/t5/QlikView/Records/m-p/927337#M968092 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">i have one table like fields YEAR,PRODUCT,SALES .each field have 5 records. When i go for Relode&nbsp;&nbsp; i want&nbsp;&nbsp; last 3 records.</SPAN></P><P></P><P>How i will&nbsp; Get the&nbsp; Last 3 records ?</P></BODY></HTML> Wed, 23 Sep 2015 17:19:34 GMT https://community.qlik.com/t5/QlikView/Records/m-p/927337#M968092 qlikview979 2015-09-23T17:19:34Z Re: Records https://community.qlik.com/t5/QlikView/Records/m-p/927338#M968093 <HTML><HEAD></HEAD><BODY><P>You can sort the table in the order you want and use the FIRST prefix:</P><P></P><P>Like:</P><P></P><P>First 3 Load *</P><P>FROM ....;</P><P></P><P>Cheers,</P><P>Patric</P></BODY></HTML> Wed, 23 Sep 2015 17:33:37 GMT https://community.qlik.com/t5/QlikView/Records/m-p/927338#M968093 pamaxeed 2015-09-23T17:33:37Z Re: Records https://community.qlik.com/t5/QlikView/Records/m-p/927339#M968094 <HTML><HEAD></HEAD><BODY><P>Can you&nbsp; Explain&nbsp; one&nbsp; Example ?</P></BODY></HTML> Wed, 23 Sep 2015 17:40:35 GMT https://community.qlik.com/t5/QlikView/Records/m-p/927339#M968094 qlikview979 2015-09-23T17:40:35Z Re: Records https://community.qlik.com/t5/QlikView/Records/m-p/927340#M968098 <HTML><HEAD></HEAD><BODY><P>Here you are...</P><P></P><P>Cheers,</P><P>Patric</P></BODY></HTML> Wed, 23 Sep 2015 17:48:48 GMT https://community.qlik.com/t5/QlikView/Records/m-p/927340#M968098 pamaxeed 2015-09-23T17:48:48Z