# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
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

1 Solution

Accepted Solutions
MVP

Hi

Try like this

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

Thanks & Regards,
Mayil Vahanan R
7 Replies
MVP & Luminary

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

- Marcus

Hi,

use max(total<columnName> abianti)

Regards

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

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

Master II

Hi Clovati,

Try like this:

Exp1:

max(total<regione>abianti)

exp2:

max(total<facia>abianti)

Regards

KC

Best Regards,
KC
MVP

Hi clovati, can you try this?:

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

MVP

Hi

Try like this

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

Thanks & Regards,
Mayil Vahanan R
Specialist

Hi

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

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

Community Browser