Choose Specific rows of data.

[Andrew_Maynard1]

I have a data set with a PolicyNumber & Date columns (+other columns). I want to filter to 1 line per Policy Number & the most recent Date. (essentially a DISTINCT[PolicyNumber] by Max(Date)). How can I do this in QlikView ?

Where would be a good place to learn more about basic filtering & aggregation of data tables in qlikview ?

[BrunPierre]

Hi, something like this?

tmpBaseData:
LOAD * FROM SouceTable;

Noconcatenate
FinalTable:
LOAD DISTINCT [PolicyNumber] as [PolicyNumber],
     Max(Date) as Date,
     Column1,
     Column2,
     Column3

Resident tmpBaseData
Group By [PolicyNumber], Column1, Column2, Column3;

DROP Table tmpBaseData;