Why does this combination not work?

Tue, 17 Nov 2015 16:22:59 GMT

The code in the black text works on its own, but when I add the code highlighted in red it freezes up. Does it have something to do with using the same table (Loans) twice?

Thanks.

Date_First_120:

LOAD

acct_nbr,

FirstSortedValue(prod_dt, prod_dt) as Date_First_120

Resident Loans

Where days_in_arears >= 120

Group by acct_nbr;

Left Join (Loans)

LOAD distinct *

Resident Date_First_120;

Drop Table Date_First_120;

Date_First_30:

LOAD

acct_nbr,

FirstSortedValue(prod_dt, prod_dt) as Date_First_30

Resident Loans

Where days_in_arears >= 30

Group by acct_nbr;

Left Join (Loans)

LOAD distinct *

Resident Date_First_30;

Drop Table Date_First_30;

Re: Why does this combination not work?

Clever_Anjos — Tue, 17 Nov 2015 16:42:00 GMT

How many rows Loans table have?

What do you intend with FirstSortedValue(prod_dt, prod_dt) ? Min(prod_dt) isn´t enough?

topic Why does this combination not work? in QlikView

Why does this combination not work?

Re: Why does this combination not work?