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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.