topic Re: Earliest Date in QlikView

Earliest Date

Anonymous — Thu, 29 May 2014 18:18:19 GMT

So I am creating a table that displays account numbers and certain dates that correspond with the account number. I am wondering how to only display the earliest date for each account number as opposed to every date for each account number.

Tried using min and firstvalue and couldnt get either to work

LoanLoss:

LOAD

acct_nbr as distinctAcct,

prod_dt as prod_dt2

Resident Loans

where is90 = 1;

Re: Earliest Date

Anonymous — Thu, 29 May 2014 18:22:28 GMT

The min() function should work. You're missing something... Can you upload your QV file?

Re: Earliest Date

eduardo_sommer — Thu, 29 May 2014 18:23:22 GMT

Try this

LoanLoss:

Load

acct_nbr as distinctAcct,

date(min(prod_dt)) as prod_dt2

Resident Loans

where is90 = 1

group by acct_nbr;

Eduardo

Re: Earliest Date

Anonymous — Thu, 29 May 2014 18:28:00 GMT

This worked! Thank you!