Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
anavin33
New Contributor II

Getting Data on a certain date

I am trying to get data from a certain date. I have the [Latest Recorded Date] variable already created and working but cannot figure out how to get data thats just from that date specifically. The Tmp table is what i have been attempting but it crashes

LoanLoss2:

Left Join (LoanLoss)

Load

acct_nbr as distinctAcct,

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

Resident Loans

group by acct_nbr;

Tmp:

Load

days_in_arears as Daysarears,

If(prod_dt = date(max(prod_dt)), days_in_arears, )

Resident Loans;

3 Replies
Not applicable

Re: Getting Data on a certain date

Hi Ashley

If(prod_dt = date(max(prod_dt)), days_in_arears )   comma not needed if there is no default value.

but what you can do is use EXISTS like

Load

days_in_arears as Daysarears

Resident Loans

WHERE EXISTS([Latest Recorded Date], days_in_arears)     // Will take records only if dates match

;

best regards

chris

anavin33
New Contributor II

Re: Getting Data on a certain date

This crashes the program. Thank you though

venkatg6759
Contributor III

Re: Getting Data on a certain date

Try this

Tmp:

Load

days_in_arears as Daysarears,

Resident Loans Where prod_dt=[Latest Recorded Date];

Community Browser