Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Find Min value and retrieve other field in same record

Try FirstSortedValue()

FirstSortedValue(Date, seconds)

-Rob

4 Replies

Re: Find Min value and retrieve other field in same record

Try FirstSortedValue()

FirstSortedValue(Date, seconds)

-Rob

Not applicable

Re: Re: Find Min value and retrieve other field in same record

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.

MVP
MVP

Re: Find Min value and retrieve other field in same record

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

Re: Find Min value and retrieve other field in same record

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

Community Browser