topic Re: Finding first date in table in QlikView

Finding first date in table

Thu, 14 Jun 2012 10:49:17 GMT

I have a table of sales reps, their customers, and the dates they met with the customers. A sales rep can meet a customer many times, e.g.

SalesRep	Customer	Meeting Date
Jack	ABC	1/4/2012
Jack	ABC	1/20/2012
Jill	XYZ	2/6/2012
Jill	XYZ	2/7/2012
Jack	DEF	1/11/2012

I want to find the first date each rep met with each customer. Eg. Jack, ABC, 1/4/2012, Jill, XYZ, 2/6/2012, Jack, DEF, 1/11/2012. I tried "min(meetingdate)", but it returns a value for each meeting. I tried firstsortedvalue(meetingdate,customer), but that didn't return anything (e.g. all results were "-"). Any thoughts?

Re: Finding first date in table

Thu, 14 Jun 2012 11:02:40 GMT

im not sure what youre trying to achive here,

but i think that if at data extraction phase you will do somthing like

'select distinct salesrep, customer, min(meeting date) from....'

it should work.... no?

Re: Finding first date in table

Miguel_Angel_Baeyens — Thu, 14 Jun 2012 11:27:35 GMT

Hi,

Try ysing the function FirstSortedValue() and Min() to get the first date (lowest date) where the sales rep met the customer.

Hope that helps.

Miguel