topic Re: Get the Last Row from Table by Script in QlikView

Get the Last Row from Table by Script

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

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!!

Re: Get the Last Row from Table by Script

sunny_talwar — Thu, 15 Dec 2016 19:41:11 GMT

May be using LastValue() function:

LastValue - script function ‒ QlikView

Re: Get the Last Row from Table by Script

its_anandrjs — Thu, 15 Dec 2016 19:53:45 GMT

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