Pick latest 2 dates

manojkulkarni — Thu, 19 Feb 2015 01:23:13 GMT

Good Morning to all,

I need to get latest 2 date fields during load to process another statement. How can we achieve this during load of QVD.

Is there any function or way to get only latest 'N' dates from a QVD. BELOW is the sample with expected result

eg:

I have following data

01/12/2014

15/12/2014

31/12/2014

01/01/2015

31/01/2015

expected result

31/12/2014

31/01/2015

Re: Pick latest 2 dates

Miguel_Angel_Baeyens — Thu, 19 Feb 2015 01:31:20 GMT

Hi Manoj,

It should be something like

Date:
 LOAD Date, Year(Date) AS Year INLINE [   
 Date  
 01/12/2014  
 15/12/2014  
 31/12/2014  
 01/01/2015  
 31/01/2015  
 ];  
 
 MaxDatesPerYear:
 LOAD Year, Date(Max(Date)) AS SelectedDate
 RESIDENT Date
 GROUP BY Year; 
 
 DROP TABLE Date;

Miguel

EDIT: Reviewed code

topic Pick latest 2 dates in QlikView

Pick latest 2 dates

Re: Pick latest 2 dates