Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
london1980
New Contributor

Pick the most recent date

Hello,

One of my tables has dates and comments for SKU's in my catalogue. I just want to see the most recent comment in my Straight Table.

     Date              SKU          Comment

-----------------      ------------    ----------------------

05/11/2015         B123       Will be available in 23/Nov       --------------> most recent comment that I want to see

04/11/2015         B123       Awaiting response

Can anyone help with a solution?

Thanks

MT

1 Solution

Accepted Solutions
MVP
MVP

Re: Pick the most recent date

Try

=FirstSortedValue( Comment, -Date)

assuming Date has a numeric representation, like a Date created by QV date functions.

3 Replies
MVP
MVP

Re: Pick the most recent date

Try

=FirstSortedValue( Comment, -Date)

assuming Date has a numeric representation, like a Date created by QV date functions.

matthewdavies
New Contributor II

Re: Pick the most recent date

Another way is to use

=Max(Date)

This function can be used in the script or on tables as well so quite nifty.

balrajahlawat
Esteemed Contributor

Re: Pick the most recent date

You can try:

LastValue(Comment)

group by Date

Community Browser