topic Show max value when selecting in QlikView

Show max value when selecting

Thu, 05 Nov 2009 23:30:19 GMT

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

Show max value when selecting

Thu, 05 Nov 2009 23:35:35 GMT

You can use Set Analysis. For the LED:

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

Show max value when selecting

Fri, 06 Nov 2009 04:13:34 GMT

There is nothing like this set analysis

Thank you very much

Show max value when selecting

hectorgarcia — Fri, 06 Nov 2009 06:07:10 GMT

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

Show max value when selecting

Sat, 07 Nov 2009 02:46:15 GMT

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.