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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

no date

Hi all,

 

Is there a function that allows you to take the most recent entry even if there is no date field?

 

thnks

sony

Labels (2)
1 Solution
2 Replies
Vegar
MVP
MVP

How would you know that it is the latest entry if you don't have a date or timestamp field? Do you have any other numeric fields like an ID that increases in value for each record? If so then you can use that field instead of the date field for fetching the latest.

If the latest is the last row of your source then you could look into the peek() function to grab the correct record.