Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Limiting shown data

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_nbrdate_closedmortgagorprod_dtrisk_amt
xxxx-xxx-xx8-AprBob1/31/20090
xxxx-xxx-xx
8-AprBob2/28/20090
xxxx-xxx-xx
8-AprBob3/31/2009652,498
xxxx-xxx-xx
8-AprBob4/30/20090

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:

mortgagorprod_dtrisk_amt
Bob1/31/20090
Bob3/31/2009652,498

Thanks!

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hello,

In Qlikview

LOAD distinct

morgagor,

risk_amt

Min(prod_dt) as prod_dt

from ExcelFile

Group by morgagor, risk_amt;


View solution in original post

2 Replies
Highlighted
Partner
Partner

Hello,

In Qlikview

LOAD distinct

morgagor,

risk_amt

Min(prod_dt) as prod_dt

from ExcelFile

Group by morgagor, risk_amt;


View solution in original post

Highlighted
Not applicable

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!