https://community.qlik.com/t5/App-Development/First-Sorted-Value/m-p/2525089#M106971 <P>I have a date like below,</P><P>| Status_Desc | Status Date | System Date |<BR />| Returned | 08.04.2025 08:02 | 08.04.2025 15:24 |<BR />| Delivered | 02.04.2025 16:58 | 08.04.2025 15:24 |</P><P>I want to display the Staus_Desc based on Last inserted System date</P><P>=FirstSortedValue(STATUS_DESC,-STATUS_DATE)</P><P>This does not give any results as the system date is same for both the lines.. If there are two entries with same System date, do we have any option to show any one of the Status_desc. Or please suggest an alternative to achieve this.</P> Wed, 23 Jul 2025 13:34:36 GMT Venthan 2025-07-23T13:34:36Z https://community.qlik.com/t5/App-Development/First-Sorted-Value/m-p/2525089#M106971 <P>I have a date like below,</P><P>| Status_Desc | Status Date | System Date |<BR />| Returned | 08.04.2025 08:02 | 08.04.2025 15:24 |<BR />| Delivered | 02.04.2025 16:58 | 08.04.2025 15:24 |</P><P>I want to display the Staus_Desc based on Last inserted System date</P><P>=FirstSortedValue(STATUS_DESC,-STATUS_DATE)</P><P>This does not give any results as the system date is same for both the lines.. If there are two entries with same System date, do we have any option to show any one of the Status_desc. Or please suggest an alternative to achieve this.</P> Wed, 23 Jul 2025 13:34:36 GMT https://community.qlik.com/t5/App-Development/First-Sorted-Value/m-p/2525089#M106971 Venthan 2025-07-23T13:34:36Z https://community.qlik.com/t5/App-Development/First-Sorted-Value/m-p/2525090#M106972 <P>ik you do&nbsp;<SPAN>=FirstSortedValue(distinct STATUS_DESC,-STATUS_DATE)</SPAN></P> Wed, 23 Jul 2025 13:38:04 GMT https://community.qlik.com/t5/App-Development/First-Sorted-Value/m-p/2525090#M106972 JHuis 2025-07-23T13:38:04Z