Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: First Sorted Value With Dates and Conditions

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

Re: First Sorted Value With Dates and Conditions

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

Highlighted
Creator III
Creator III

Re: First Sorted Value With Dates and Conditions

Thank you