Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
JonathanKelly
Contributor III
Contributor III

Table filtering

I have a column of names and a column of dates and times, I want to show the first instance of each name in the data set against the earliest date/time.

I have a filter pane that allows me to select a date but I need a filtering expression I believe to set my updatedBy and updatedON columns to only show the first instance of each

Labels (4)
3 Replies
Chanty4u
MVP
MVP

Could you please post some sample data and with expected output .

JonathanKelly
Contributor III
Contributor III
Author

I've attached an excel document, data on the left and expected output on the right.

I have names repeating but I only need the first instance of the name and the time associated with it.

Or
MVP
MVP

Sounds like you're looking for either Min()/Max() or for FirstSortedValue(), but it's hard to say exactly without understanding the specifics.