Limiting shown data

Wed, 10 Dec 2014 15:48:57 GMT

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

xxxx-xxx-xx

8-Apr

Bob

2/28/2009

xxxx-xxx-xx

8-Apr

Bob

3/31/2009

652,498

xxxx-xxx-xx

8-Apr

Bob

4/30/2009

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!

Re: Limiting shown data

yduval75 — Wed, 10 Dec 2014 15:53:15 GMT

Hello,

In Qlikview

LOAD distinct

morgagor,

risk_amt

Min(prod_dt) as prod_dt

from ExcelFile

Group by morgagor, risk_amt;

Re: Limiting shown data

Wed, 10 Dec 2014 16:45:38 GMT

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!

topic Limiting shown data in QlikView

Limiting shown data

Re: Limiting shown data

Re: Limiting shown data