Discussion Board for collaboration on QlikView Scripting.
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?
FirstSortedValue(prod_dt, prod_dt) as Date_First_120
Where days_in_arears >= 120
Group by acct_nbr;
Left Join (Loans)
LOAD distinct *
Drop Table Date_First_120;
FirstSortedValue(prod_dt, prod_dt) as Date_First_30
Where days_in_arears >= 30
Drop Table Date_First_30;
Go to Solution.
How many rows Loans table have?
What do you intend with FirstSortedValue(prod_dt, prod_dt) ? Min(prod_dt) isn´t enough?