Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
dmelillo
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
sunny_talwar

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
sunny_talwar

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

dmelillo
Creator III
Creator III
Author

Thank you