# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider - Maximize your investment, Join this webinar, May 26th. Register Today
cancel
Showing results for
Did you mean:
Creator III

## Set Analysis Max Date Record

Hi all,

Need the max record, depending on the max date. See below.

Can not use something like that, because there is nothing to aggregate (for instance in Column "Sync_Key"):

Sum({\$<%Date = {"\$(=Max(%Date))"}>} Sync_Key)

Thanks.

 %Date User Sync_Key 01.01.2020 Albert Albert | 01.01.2020 02.01.2020 Albert Albert | 02.01.2020 03.01.2020 Albert Albert | 03.01.2020 01.01.2020 Stefan Stefan | 01.01.2020 02.01.2020 Stefan Stefan | 02.01.2020 Result: %Date User Sync_Key 03.01.2020 Albert Albert | 03.01.2020 02.01.2020 Stefan Stefan | 02.01.2020
Labels (1)
• ### SaaS

5 Replies
MVP

@george54 May be this

Dimension
User

Expression
FirstSortedValue(Sync_Key, -%Date)
Date(Max(%Date))

Creator III
Author

Don't understand. These are to functions; where to put it? If I put only FirstSortedValue(Sync_Key, -%Date) in a separate Dimension, does not work

MVP

@george54 You need it as a dimension? Try this

User
Aggr(FirstSortedValue(Sync_Key, -%Date), User)
Aggr(Max(%Date), User)

Champion III

can you try this?

=sum({<%Date={"\$(=Date(Max(%Date),'DD.MM.YYYY'))"}>}  sync_key)

Best

Chanty

Creator III
Author

Hi and thanks all of you, but none of these formula worked:

User Aggr(FirstSortedValue(Sync_Key, -%Date), User) Aggr(Max(%Date), User) // Error: not valid Dimension

Sum({<%Date={"\$(=Date(Max(%Date),'DD.MM.YYYY'))"}>} Sync_Key)                     // Error: not valid Dimension

User Aggr(FirstSortedValue(Sync_Key, -%Date), User) Aggr(Max(%Date), User) // Syntax Error

FirstSortedValue(Sync_Key, -%Date) Date(Max(%Date))                                                // Syntax Error

Have only these 4 Dimensions in the Outputtable, no measures: