Returning the highest value from a list - Part Two

Mon, 28 Jan 2013 19:57:43 GMT

Hi, after the excellent help I receive at the weekend from "whiteline"

I have run into a problem and I think it has something to do with needing to add a distinct function to the experession or modifying the rangesum function.

The issue I'm having is that the Top 3 results are returned in the chart and then I'm using the same expression within a Text Object to return the total value of the Top 3 items.

However when there are duplicate results (values) e.g. 1st=3.08 2nd=3.08 it returns the 1st value, the 3rd value and the 4th value as a total.

Appreciate the help.

Rob

Expression

=num(rangesum(

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

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

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

topic Returning the highest value from a list - Part Two in QlikView

Returning the highest value from a list - Part Two