Get the Last Row from Table by Script

[microwin88x]

Hello,

I have the following table:

ID_TCKT	STATUS	DATE	TIME	MONTH	PERIOD
TCKT003	Planning In Progress	03/10/2016	16:27:12	Oct	Oct 2016
TCKT003	Request For Change	03/10/2016	16:27:12	Oct	Oct 2016

What I need is to get the MAX DATE/TIME with the corresponding Status. In this case both DATE/TIMEs are the same, that's why I need to get only one status and this would have to be the last row: Request For Change.

Do you know how could I do that by Script?

Thank you!!

[sunny_talwar · Accepted solution]

May be using LastValue() function:

LastValue - script function ‒ QlikView

[its_anandrjs]

Trying this way

Load

ID_TCKT,

Date(Max(DATE)) as MaxDate,

Time(Max(TIME)) as MaxTime

Resident Table Where STATUS = 'Request For Change';

Regards

Anand