# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Highlighted
Partner

## max value of expression for each dimension

Hi all.

I have the column in yellow as input and wish to obtain the measure in green.

2 regione -> 2 values

3 fascia -> 3 values

Tags (2)
1 Solution

Accepted Solutions
MVP

## Re: max value of expression for each dimension

Hi

Try like this

=Max(Total<regione> Aggr(Sum(ABITANTI), regione, fascia, provincia)

7 Replies
MVP & Luminary

## Re: max value of expression for each dimension

Try it with: max(total <regione> abianti) respectively max(total <fascia> abianti).

- Marcus

## Re: max value of expression for each dimension

Hi,

use max(total<columnName> abianti)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Partner

## Re: max value of expression for each dimension

Thanks! But, if ABITANTI would be an EXPRESSION like sum(abitanti)? How would change max(total <regione> abianti) ?

Honored Contributor II

## Re: max value of expression for each dimension

Hi Clovati,

Try like this:

Exp1:

max(total<regione>abianti)

exp2:

max(total<facia>abianti)

Regards

KC

Best Regards,
KC
MVP

## Re: max value of expression for each dimension

Hi clovati, can you try this?:

Max(TOTAL <regione> Aggr(Sum(abianti), regione, provincia))

MVP

## Re: max value of expression for each dimension

Hi

Try like this

=Max(Total<regione> Aggr(Sum(ABITANTI), regione, fascia, provincia)

Valued Contributor

## Re: max value of expression for each dimension

Hi

for Max Abitanti for Regione use expression  :  max(total<regione>abitanti)

and for max abitanti for fascia use :   max(total<fascia>abitanti)