Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Find max(a) of the element with the highest min(b)

Hi guys,

I have a table of time measurements where the dimensions are component and user groups:

data structure.PNG

Per each of these there is a min_time and max_time values.

I want to display the min and max of these values per each user group (they are 1, 5, 10, 50, 100...).

The proble is that I need MAX(min_time) and MAX(max_time), but the latter should correspond to the component with the max(min_time).

The table below is what I naturally get:

wrong_tabl.PNG

I need the formula to display 17.491 since this is the component with the max(min_time) value.

Any ideas on how to accomplish this?

Thanks in advance.

Valera

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Well, as it turned out the solution was simpler than the problem.

To find the value of the element with max(a) value it was enough to use the function FirstSortedValue.

The final formula is simple as it is:

=FirstSortedValue (max_time, -min_time)

solution.PNG

View solution in original post

2 Replies
Not applicable
Author

Hi,

Can you post a sample of the data?

By Rebeca

Anonymous
Not applicable
Author

Well, as it turned out the solution was simpler than the problem.

To find the value of the element with max(a) value it was enough to use the function FirstSortedValue.

The final formula is simple as it is:

=FirstSortedValue (max_time, -min_time)

solution.PNG