topic Re: Getting Data on a certain date in QlikView

Getting Data on a certain date

Anonymous — Tue, 03 Jun 2014 14:12:36 GMT

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;

Re: Getting Data on a certain date

Tue, 03 Jun 2014 14:17:58 GMT

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

Re: Getting Data on a certain date

Anonymous — Tue, 03 Jun 2014 14:45:15 GMT

This crashes the program. Thank you though

Re: Getting Data on a certain date

venkatg6759 — Tue, 03 Jun 2014 14:52:21 GMT

Try this

Tmp:

Load

days_in_arears as Daysarears,

Resident Loans Where prod_dt=[Latest Recorded Date];