Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

valera_sh
Contributor II

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

Tags (3)
1 Solution

Accepted Solutions
valera_sh
Contributor II

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

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

2 Replies
Not applicable

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

Hi,

Can you post a sample of the data?

By Rebeca

valera_sh
Contributor II

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

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

Community Browser