Table - Distinct by recent day accessed

[vgadang1]

Hi,

Here is the sample data I have in a Table, I want to show each app only 1 time by recent access date, for example  App 1 was accessed multiple times and I want to bring in only Row 3 for app 1 (recent access date).  How can I achieve this

Row	AppName	App Reload date	Days Last Accessed
1	App1	10/19/2022	64
2	App1	10/20/2022	63
3	App1	10/21/2022	62
4	App2	10/22/2022	61
5	App2	10/23/2022	60
6	App3	10/24/2022	59
7	App3	10/25/2022	58
8	App3	10/26/2022	57
9	App3	10/27/2022	56

[AronC]

@vgadang1 

You can use the AppName as dimension ant FirstSortedValue as expression for the other columns. For example: =FirstSortedValue([App Reload date],-Row)

See the expressions in the other columns in the table below.

[anat · Accepted solution]

@cavga ,can u try using Firstsortedvalue  or do the inner join .

https://community.qlik.com/t5/QlikView-App-Dev/Trying-to-pull-most-recent-record-by-date/td-p/871836

https://community.qlik.com/t5/QlikView-App-Dev/Get-Max-Date-For-Each-id/td-p/1406454