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

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
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 (3)
1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

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. 

Chanty4u
MVP
MVP