Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
CasperQlik
Creator
Creator

Display text value for most recent entry

I have a dataset that contains a list of of user entries. I need to display the most recent value in the entry column in a text object. 

How would I fetch that single entry and how would I display it in a KPI/Text object.

Any help is appreciated

 

/Casper

1 Solution

Accepted Solutions
Nagaraju_KCS
Specialist III
Specialist III

You can use FirstSortedValue function and use this expression

=FirstSortedValue(column, -DateColumn)

View solution in original post

2 Replies
Nagaraju_KCS
Specialist III
Specialist III

You can use FirstSortedValue function and use this expression

=FirstSortedValue(column, -DateColumn)

CasperQlik
Creator
Creator
Author

This works, thanks a lot!