Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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

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
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
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) ?

jyothish8807
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

Re: max value of expression for each dimension

Hi clovati, can you try this?:

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

Re: max value of expression for each dimension

Hi

Try like this

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

ashwanin
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)