topic Re: Returning the highest value from a list in QlikView

Returning the highest value from a list

Sun, 27 Jan 2013 03:22:58 GMT

Hi, I know this might be very simple for many of you but I'm struggling to find the solution.

I want to return the highest value from a set of results, in this case Ans_Minutes that holds 28 results.

I have been trying Max and FirstSortedValue but getting nowhere!

I have added the qvw below - I'm trying to populate the two Text Objects in the file

One with the Highest Value found in the Table

The other adding the 3 highest values that are illustrated in the Focus e.g. 193.0, 123.2 & 101.7 = 417.9

Hope this makes more sense.

Thanks

Rob

whiteline — Sun, 27 Jan 2013 12:27:54 GMT

Maximum:

=num(Max({$<Response_Level_2={*}>}aggr(sum (Ans_Minutes), Response_Level_2, Ans_Text))/60,'##0')

Three highest values:

=num(rangesum(

Max({$<Response_Level_2={*}>}aggr(sum (Ans_Minutes), Response_Level_2, Ans_Text), 1),

Max({$<Response_Level_2={*}>}aggr(sum (Ans_Minutes), Response_Level_2, Ans_Text), 2),

Max({$<Response_Level_2={*}>}aggr(sum (Ans_Minutes), Response_Level_2, Ans_Text), 3))/60,'##0')

Sun, 27 Jan 2013 15:41:28 GMT

Excellent, thank you again for your help.

Rob