Show max value when selecting

[#1]

hi guys,

Pls see the attach file.

I have 2 fields,when I'm making selections in the dimension field (called "DIM" ) I can choose as many

values as I want.

BUT in the led near by I need that the value will be only the sum of the highest

dimension (value) that I had choosen.

numeric example: ( again see attach file...)

when I will choose in the field "DIM" the values 3,4,5 I want to see in the green led the

value of 5000 (which fitting to "5" ) and not 12,000 which is

the sum of 3+4+5 (3000+4000+5000=12,000)

Hope you got me.

Thanx,

David

[#2 · Accepted solution]

You can use Set Analysis. For the LED:

sum({<Dim = {$(=Max(Dim))}>}sale)

[#3]

There is nothing like this set analysis

Thank you very much

[hectorgarcia]

I have a very similar problem but i couldn't apply the solution you provided, please find a sampkle of the problem description

I will apprciate your help

[#5]

I'm having trouble getting your guage working correctly, but I figured out a few things I thought I could share.

First, I think you are having trouble because your MonthYear column is a string, not a date. Therefore, Max(MonthYear) is nothing, because QlikView can't calculate the Max of a string. In order to get the Max selected MonthYear, you need to use (I set this as a variable value):

=Date(Max(Date#(MonthYear, 'MMM-YYYY')), 'MMM-YYYY')

Then, in a chart, I was able to use CATEGORIA as a dimension and for an expression (where vMaxMY is the variable from above):

Max({<MonthYear={"$(vMaxMY)"}>}Bsum3ch)

If those three categories are selected, the Average of those three expressions will be your .73% as long as Jul-2009 is the Max selected MonthYear.

Now, you just need to get that working with the Aggr function. I've attached what I came up with so far.