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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Find Min value and retrieve other field in same record

I have a CSV file containing activities where each activity has a time (seconds) and date associated with it. I want to show the activity with the shortest time and it's corresponding date in a text box. I can find the shortest time by using the Min function, but how do I get the corresponding date?

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Try FirstSortedValue()

FirstSortedValue(Date, seconds)

-Rob

View solution in original post

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Try FirstSortedValue()

FirstSortedValue(Date, seconds)

-Rob

Not applicable
Author

Hi Rob Wunderlich

It seems a long ago topic, but I had the same issue. I tried to use the FirstSortedValue to get the supplier have the min amount in each Producto, but it didn't work. could you please take a look on my attached example.

tresesco
MVP
MVP

Jay,

It would be better if you create a new thread and post your question there. Generally you won't get much attention in an answered thread. And yes, please explain your expected output.

Not applicable
Author

Thanks for your suggestion Tresesco, I will create the new thread with more detail info and expected output