topic First Sorted Value With Dates and Conditions in QlikView

First Sorted Value With Dates and Conditions

Anonymous — Wed, 18 Jul 2018 18:51:52 GMT

I have data that looks like

Person/CreatedDate/CloseDate/Won

Bob/(1/11/2011)/(1/12/2011)/1

For each person, I am trying to get the FIRST CLOSED DATE that is GREATER THAN OR EQUAL TO each individual's CREATE DATE.

What I have so far is below but it is not working. Any help is appreciated!

=FirstSortedValue({< Won = {'1'}, [Close Date]={">=Date(OppUserCreatedDate,'MM/DD/YYYY')"}>} [Close Date], [Close Date])

- dave

sunny_talwar — Wed, 18 Jul 2018 18:57:28 GMT

Since each person can have a different CreatedDate... set analysis won't work here... may be use an if statement

Max({<Won = {'1'}>} If([Close Date] >= OppUserCreatedDate, [Close Date]))

Anonymous — Thu, 19 Jul 2018 14:48:39 GMT

Thank you