get sum of maximum values

[#1]

get sum of maximum values

[#2]

Hi,

Use Sum(Max(FieldName))  Or post your sample data and need with some more information

[suniljain]

You can use Max(Sales) in expression .

[MK_QSL]

If your field is as a dimension in chart, you can use sum (field_name)

Example dimension = customer name

Expression = max (ordervalue) This will give you max order value by customer.

[#5]

Hi

use the rank function or dimension limits tab or max function

[#6]

Let's say you have a Measure Field and a Dimension Field for that Measure

DIMENSION MEASURE

A                 5

A                 6

B                 7

C                 8

A                 7

B                 1

If you are trying to sum the maximum values you are trying to:

First:  geting the maximum values:

A                7

B                7

C               8

so you want to get a LIST of maximum values --> thats in qlikview

AGGR(Max(Measure),Dimension)   ---> something like SELECT MAX(MEASURE) GROUP BY DIMENSION

Then you want to make the sum so--->

SUM(AGGR(Max(Measure),Dimension) )

[senpradip007]

Hi nishani,

Please upload your application otherwise it is meaningless.