Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for
Did you mean:
Partner - Creator

## 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

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Partner - Creator
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