topic Fetching 5th last value from column? in QlikView https://community.qlik.com/t5/QlikView/Fetching-5th-last-value-from-column/m-p/868423#M995300 <HTML><HEAD></HEAD><BODY><P>Hi experts..</P><P>How to fetch 5th last value from column in frontend using aggr() &amp; without Max().</P><P>Plz help its urgent.</P><P></P><P>Thanxx in advance.</P></BODY></HTML> Thu, 02 Jul 2015 06:33:54 GMT Anonymous 2015-07-02T06:33:54Z Fetching 5th last value from column? https://community.qlik.com/t5/QlikView/Fetching-5th-last-value-from-column/m-p/868423#M995300 <HTML><HEAD></HEAD><BODY><P>Hi experts..</P><P>How to fetch 5th last value from column in frontend using aggr() &amp; without Max().</P><P>Plz help its urgent.</P><P></P><P>Thanxx in advance.</P></BODY></HTML> Thu, 02 Jul 2015 06:33:54 GMT https://community.qlik.com/t5/QlikView/Fetching-5th-last-value-from-column/m-p/868423#M995300 Anonymous 2015-07-02T06:33:54Z Re: Fetching 5th last value from column? https://community.qlik.com/t5/QlikView/Fetching-5th-last-value-from-column/m-p/868424#M995303 <HTML><HEAD></HEAD><BODY><P>Hi Sonal,</P><P></P><P>Try </P><P></P><P>=FieldValue('FieldNAME', 5)</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 02 Jul 2015 15:13:26 GMT https://community.qlik.com/t5/QlikView/Fetching-5th-last-value-from-column/m-p/868424#M995303 jagan 2015-07-02T15:13:26Z Re: Fetching 5th last value from column? https://community.qlik.com/t5/QlikView/Fetching-5th-last-value-from-column/m-p/868425#M995305 <HTML><HEAD></HEAD><BODY><P>What does '5th last value' mean? By order of the values or by row number? min(Value, 5) or bottom(Value, 5)?</P></BODY></HTML> Thu, 02 Jul 2015 15:15:15 GMT https://community.qlik.com/t5/QlikView/Fetching-5th-last-value-from-column/m-p/868425#M995305 Gysbert_Wassenaar 2015-07-02T15:15:15Z