Max Value of A Ratio

[Anonymous]

I have a straight chart and trying to pick the Max value from one column and show it in the next column (repeat that value in all rows), the column form where max value should be picked is containing a ratio i.e. Field A/ Field B.

Any suggestion ?

Industry     Sales     Ratio     Max of Ratio

A               $100     4.5         7.5

B               $110     7.5         7.5

C               $105     6.8         7.5

Where, column Ratio could be like: Field A / Field B

[MK_QSL]

Max(TOTAL Ratio)

Or

Max(TOTAL (FieldA/FieldB))

[PrashantSangle]

Hi,

use variable,

store max ratio in variable then use in it your dimension,

varMaxRation=max(Field A / Field B)

Regards,

PS

[maxgro]

you already get the answer from previous post (TOTAL)

some more useful (I hope) explanations from QlikTech and online help

If the word total occurs before expression the calculation will be made over all possible values given the current selections but disregarding the chart dimension variables.

The total qualifier may be followed by a list of one or more field names within angle brackets. These field names should be a subset of the chart dimension variables. In this case the calculation will be made disregarding all chart dimension variables except those listed, i.e. one value will be returned for each combination of field values in the listed dimension fields. Also fields which are not currently a dimension in a chart may be included in the list. This may be useful in the case of group dimensions, where the dimension fields are not fixed. Listing all of the variables in the group causes the function to work when the cycle or drill-down level changes.

[preminqlik]

max(total Ratio)

[Anonymous]

Thank you all. Variable approach worked. Even though same expression (used for variable) in the chart does not work.