https://community.qlik.com/t5/QlikView/Data-has-multiple-part-numbers-and-requirement-dates-Need-one/m-p/1809267#M1212408 <P><SPAN>Hello Qlikview experts. I have an issue I am hoping you can help with.</SPAN></P><P>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:</P><P>1) One record per part number</P><P>2) The earliest requirement date per part number</P><P>Thanks in advance.</P><P>BG</P> Thu, 20 May 2021 02:14:28 GMT bgreennc 2021-05-20T02:14:28Z https://community.qlik.com/t5/QlikView/Data-has-multiple-part-numbers-and-requirement-dates-Need-one/m-p/1809267#M1212408 <P><SPAN>Hello Qlikview experts. I have an issue I am hoping you can help with.</SPAN></P><P>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:</P><P>1) One record per part number</P><P>2) The earliest requirement date per part number</P><P>Thanks in advance.</P><P>BG</P> Thu, 20 May 2021 02:14:28 GMT https://community.qlik.com/t5/QlikView/Data-has-multiple-part-numbers-and-requirement-dates-Need-one/m-p/1809267#M1212408 bgreennc 2021-05-20T02:14:28Z