Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Uri
Creator
Creator

field value based on max value

Hi,

I have two fields in my table: main_function (string) and datetime (format - 2020-11-11 11:22:37).

I want to show main_function based on max(datetime).

Show main_function based on the latest datetime.

Can anyone help me to fix this?

BR,

Artur

 

 

 

2 Replies
Dalton_Ruer
Support
Support

Something like this will give you the Function with the max string name in the event you could have multiple functions with the same date value. 

MaxString({<= { '$(=Max(DateField))' }> } Function)

Uri
Creator
Creator
Author

Hi @Dalton_Ruer  and thanks for your reply,

it says:

Error in expression: '}' expected. 

Im not getting why...