Data has multiple part numbers and requirement dates. Need one record per part number

[bgreennc]

Hello Qlikview experts. I have an issue I am hoping you can help with.

I have master data that has part numbers, and requirement dates for the part numbers. One part number can have several different requirement dates. I tried using FirstSortedValue, but couldn't get it to work. What I need is:

1) One record per part number

2) The earliest requirement date per part number

Thanks in advance.

BG