topic Getting data after a certain date field in QlikView

Getting data after a certain date field

Anonymous — Mon, 02 Jun 2014 16:05:47 GMT

So Im trying to extract data after the [Latest Recoded Date] field. I want a number of days since that date but don't know how to specify that it MUST be from after that date.

I have the [Latest Recorded Date] variable stored and ready to use I'm just not sure how to write that i want a variable called DaysArears that starts from that date til the latest date ever recorded

LoanLoss2:

Left Join (LoanLoss)

Load

acct_nbr as distinctAcct,

date(max(prod_dt)) as [Latest Recorded Date],

max(days_in_arears) as daysinarears

Resident Loans

group by acct_nbr;

Re: Getting data after a certain date field

Mon, 02 Jun 2014 16:08:48 GMT

What are you trying to accomplish with DaysArears? If you have [Latest Recorded Date], you can use it in set analysis within your expressions to display dates from [Latest Recorded Date] to the last date your recorded...

Re: Getting data after a certain date field

Anonymous — Mon, 02 Jun 2014 16:12:05 GMT

I want DaysArears to equal the amount of days from the last recorded date, for an account, to the latest recorded date ever recorded... does that make sense?

Re: Getting data after a certain date field

Mon, 02 Jun 2014 16:27:45 GMT

date(max(date)-[Last recorded date])? This might work.

It would be easier if you could share your qvw.