Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Why does this combination not work?

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;

1 Solution

Accepted Solutions
Employee
Employee

Re: Why does this combination not work?

How many rows Loans table have?

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

1 Reply
Employee
Employee

Re: Why does this combination not work?

How many rows Loans table have?

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

Community Browser