topic Re: Fetch last two records from source in QlikView

Fetch last two records from source

ashish_2511 — Wed, 25 Nov 2020 16:16:04 GMT

Dear Community

This is how my source data looks like -

Issue - I want to fetch only the records pertaining to the latest two Inv_dates wrt to the vin_no, sorted by Inv_Date.

****E.g; In my qvw I only want the records highlighted in Red****

Your ideas will be greatly appreciated.

Thanks!

Sneh

PrashantSangle — Fri, 17 Mar 2017 11:30:11 GMT

Hi,

use firstsortedValue(field,-date)

for more details see example in help menu

Regards,

sunny_talwar — Fri, 17 Mar 2017 11:31:20 GMT

May be try this

Table:

LOAD * INLINE [

Vin_No, Inv_Date, Mileage_In

123, 3/17/2017, 15000

123, 2/17/2017, 12000

123, 1/17/2017, 10000

234, 3/17/2017, 15000

234, 2/17/2017, 12000

234, 1/17/2017, 10000

];

FinalTable:

NoConcatenate

LOAD *

Resident Table

Where Vin_No <> Previous(Previous(Vin_No))

Order By Vin_No, Inv_Date desc;

DROP Table Table;