Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

First Sorted Value With Dates and Conditions

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

1 Solution

Accepted Solutions
Highlighted

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]))

View solution in original post

2 Replies
Highlighted

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]))

View solution in original post

Creator III
Creator III

Thank you