Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
etrotter
Creator II
Creator II

Most Recent Entry

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

1 Solution
7 Replies
agigliotti
Partner - Champion
Partner - Champion

could you please add more details about your request?

craig157
Creator II
Creator II

Have a look at this article about Apply Mapping when reloading.

We've used this on a couple solutions to show the Reload Date rather than record creation date.

Makes checking logs easier!

Latest Record Flag Using ApplyMap

etrotter
Creator II
Creator II
Author

So I am trying to see the last entry for the Field "Performance Values" there is a date function, but it has dates where there are no Performance Values so when I try to use set analysis to get the max(Date) it is generally zero because there is no entry for it. I would really like to just pull the most recent Performance measure value.

agigliotti
Partner - Champion
Partner - Champion

maybe this:

Sum( {< Date = {"=Max(Date)"} >} [Performance Value] )

MK9885
Master II
Master II

Maybe use Where Not Exist in the new load and concatenate the table?

Table1:

Load

Key

ABC,

BCD,

Performance Value

From....Test1.qvd

Concatenate (Table1)

Load

Key

ABC,

BCD,

Performance Value

From UpdateTest1qvd

where not exists Performance Value;


I guess you'd need to store the Table1 into a qvd as a updateTable1.qvd and use that Update QVD to find any upated performance values?

I'm not sure if you looking for this in script or front end?

If In front end create a Rowno() as Record number and use Max (Record Number) in front end for performance

etrotter
Creator II
Creator II
Author

With the apply map, the problem is that if I use any date filters it no longer works