Set analysis

[qlikviewforum]

Using the below set analysis I finding out average utilization(After selecting the Integer and Show in Percent(%) in number tab).Now I would like to know the maximum. Can someone please help me out on this?

(SUM({<

AsOfPeriod = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod)))'}, same_day={'Y'}

  >}

    fabs(Value))

/

SUM({<

AsOfPeriod = {'>$(=date($(VMaxPeriod)-$(VDays))) <=$(=date($(VMaxPeriod)))'}, same_day={'Y'}

  >}

    fabs(Limit)))

[jonathandienst]

Hi

single table dimension:

=Max(Aggr(SUM......., dim1))             

or (multiple table dimensions):

=Max(Aggr(SUM......., dim1, dim2, ...))

Where SUM.... is your existing expression and dim1, dim2, etc are the dimensions on your table.

HTH

Jonathan