Min and max date records

[Prasad1318]

Hi,

I have 2 date fields(entry date, exit date), 1 result field, and a policy number.

I need to build the straight table chart in which I should have policy number record with min entry date and max exit date 

Eg 

Policy Number    Entry Date     Exit Date          Result

1                          24/11/2023.    21/10/2024.       100

1                          20/12/2022.     21/10/2024.        50

2.                         22/01/2020.     02/02/2023.         20

My resultant should be 

Policy Number    Entry Date     Exit Date          Result

1                          20/12/2022.     21/10/2024.        50

2.                         22/01/2020.     02/02/2023.         20

I tried using first sorted to get the date fields but for measure Result i am unable to get the proper values. 

please help me on the above

Thanks 

[morgankejerhag]

Do you want the first entry date's result to show? If so, you can use an expression like:

FirstSortedValue(Result,[Entry Date])

This assumes that Entry Date is a proper date in Qlik