Loading a table on Max date within a data set

[Brokenhips]

Having been away from Qlik for a number of years, just getting back to this and have a question.

I have a table -

PR_Id,  VehicleType,  PR_EffectiveFrom,  PR_EffectiveTo,  PR_BasicPR_Vat

45366	Car	05/10/2009 00:00	01/12/2009 00:00	11678.2609	1751.7391
45366	Car	01/12/2009 00:00	01/01/2010 00:00	12026.087	1803.913
45366	Car	01/01/2010 00:00	22/03/2010 00:00	12026.0851	2104.5649
45366	Car	22/03/2010 00:00	NULL	12225.5319	2139.4681

I want to load only the records that contain either the MAX  PR_EffectiveTo date in the set of the SAME PR_Id's or

The record with NULL as the Max PR_Effective_To date if that is present in the same PR_Id set

I.e - of the 4 records above - I want to load only the NULL records for ID 45366 or if this had a MAX date - then that record.

Thanks in advance

Broken

[hacr]

Sounds like you are interested in something like this:

https://community.qlik.com/t5/Qlik-Sense-App-Development/how-to-load-max-date-row-from-the-table/td-...

[Brokenhips]

Thats great thankyou