Limiting shown data

[#1]

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
xxxx-xxx-xx	8-Apr	Bob	2/28/2009	0
xxxx-xxx-xx	8-Apr	Bob	3/31/2009	652,498
xxxx-xxx-xx	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!

[yduval75 · Accepted solution]

Hello,

In Qlikview

LOAD distinct

morgagor,

risk_amt

Min(prod_dt) as prod_dt

from ExcelFile

Group by morgagor, risk_amt;

[#3]

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!