topic Re: Getting first/most recent records in QlikView

Getting first/most recent records

erieqlik — Mon, 26 Jan 2026 21:26:37 GMT

I have a list of project data. Multiple status records per project. I want a list of only the most recent records. I have already built the qvd of data from the data warehouse. I need to either do the data selection in the LOAD or in the dashboard. I am OK with either. I am not great with qlik load syntax and so far I have been unable to construct a sql query that would work. Nor have I been able to get FirstSortedValue to work properly.

Thanks for the help, JM

Re: Getting first/most recent records

Or — Tue, 09 May 2023 13:43:44 GMT

Load Project, Max(Date) as Date

From SomeTable;

Left Join

Load *

From SomeTable;

You could also handle this with a combination of Max() (for the date) and FirstSortedValue() (for the status and any other dimensions) but that would be clunkier, albeit potentially more efficient.

Re: Getting first/most recent records

erieqlik — Tue, 09 May 2023 14:35:00 GMT

So I get an error. This part of the query is already an inner join so perhaps this is a problem. However, I will keep trying.