topic no date in QlikView

no date

soniasweety — Fri, 15 Nov 2024 23:49:55 GMT

Hi all,

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

thnks

sony

Re: no date

Vegar — Sun, 11 Oct 2020 06:21:36 GMT

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.

Re: no date

Chanty4u — Sun, 11 Oct 2020 11:50:22 GMT

Hi,

can you try this aswell.

LastValue()

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/StringAggregationFunctions/LastValue.htm?_ga=2.12136119.2009523092.1602150027-368215561.1560504428