Qlik Community

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 
Search instead for 
Did you mean: 
clovati
Partner
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.

Capture.PNG

2 regione -> 2 values

3 fascia -> 3 values

Thanks in advance!

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

7 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

PrashantSangle

Hi,

use max(total<columnName> abianti)

Regards

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

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

jyothish8807
Master II
Master II

Hi Clovati,

Try like this:

Exp1:

max(total<regione>abianti)

exp2:

max(total<facia>abianti)



Regards

KC

Best Regards,
KC
rubenmarin

Hi clovati, can you try this?:

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

MayilVahanan

Hi

Try like this

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

Thanks & Regards,
Mayil Vahanan R

View solution in original post

ashwanin
Specialist
Specialist

Hi

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

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