Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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;