topic Re: How to get the values which contains oldest date? in QlikView

How to get the values which contains oldest date?

Wed, 09 Apr 2014 12:13:03 GMT

Hi,

I have a table box which gets data from excel file. The columns are

For e.g.:

ID Summary Date

442542 5months 23/09/2008

442542 5months 02/01/2012

How can I get the table box which contains only the values with oldest date. I,e

ID Summary Date

442542 5months 23/09/2008

Thanks.

MK_QSL — Wed, 09 Apr 2014 12:32:53 GMT

Min(Date)

UPDATE :

SCRIPT

Temp:

Load * Inline

[

ID, Summary, Date

442542, 5months, 23/09/2008

442542, 5months, 02/01/2012

];

Load

FirstSortedValue(ID, Date) as ID1,

FirstSortedValue(Summary, Date) as Summary1,

FirstSortedValue(Date, Date) as Date1

Resident Temp;

Now create a table box with dimensions

ID1, Summary1 and Date1

Wed, 09 Apr 2014 12:33:30 GMT

Thanks Manish. How can I give this in table box?

MK_QSL — Wed, 09 Apr 2014 12:35:13 GMT

replied as an update

Wed, 09 Apr 2014 12:40:06 GMT

That's super working! Thanks.