Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

anavin33
New Contributor III

Getting data after a certain date field

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;

3 Replies
Not applicable

Re: Getting data after a certain date field

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

anavin33
New Contributor III

Re: Getting data after a certain date field

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?

Not applicable

Re: Getting data after a certain date field

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

It would be easier if you could share your qvw.