topic Choose Specific rows of data. in Connectivity & Data Prep

Choose Specific rows of data.

Andrew_Maynard1 — Thu, 02 Mar 2023 11:47:29 GMT

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 ?

Re: Choose Specific rows of data.

BrunPierre — Sun, 05 Mar 2023 14:27:11 GMT

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;