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
