Min and max date records

Prasad1318 — Fri, 15 Nov 2024 20:53:54 GMT

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

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

Re: Min and max date records

morgankejerhag — Wed, 12 Feb 2025 20:40:34 GMT

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