Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have tried a few approaches here but I am not getting the required results so I figure I'd see if anyone had any insight of what direction I should go in.
I have an excel sheet loading information similar to this:
loan_nbr | date_closed | mortgagor | prod_dt | risk_amt | |
xxxx-xxx-xx | 8-Apr | Bob | 1/31/2009 | 0 | |
| 8-Apr | Bob | 2/28/2009 | 0 | |
| 8-Apr | Bob | 3/31/2009 | 652,498 | |
| 8-Apr | Bob | 4/30/2009 | 0 |
The point of the exercise is to isolate a prod_dt and risk_amt. Those would be based off of DISTINCT values of the risk_amt (including zero values) for that client and a prod_dt based off the first or minimum date that value was seen. So in this case this would be the desired result I would like to get into qlikview:
mortgagor | prod_dt | risk_amt |
---|---|---|
Bob | 1/31/2009 | 0 |
Bob | 3/31/2009 | 652,498 |
Thanks!
Hello,
In Qlikview
LOAD distinct
morgagor,
risk_amt
Min(prod_dt) as prod_dt
from ExcelFile
Group by morgagor, risk_amt;
Hello,
In Qlikview
LOAD distinct
morgagor,
risk_amt
Min(prod_dt) as prod_dt
from ExcelFile
Group by morgagor, risk_amt;
Perfect solution. I was using my group by incorrectly. With a few minor changes in Qlikview I should get what I am looking for. Thanks a lot!