topic Re: max value of expression for each dimension in QlikView

max value of expression for each dimension

clovati — Wed, 25 Nov 2020 16:16:04 GMT

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

Thanks in advance!

marcus_sommer — Tue, 26 Jul 2016 07:18:39 GMT

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

- Marcus

PrashantSangle — Tue, 26 Jul 2016 07:23:17 GMT

Hi,

use max(total<columnName> abianti)

Regards

clovati — Tue, 26 Jul 2016 08:06:08 GMT

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

jyothish8807 — Tue, 26 Jul 2016 08:17:37 GMT

Hi Clovati,

Try like this:

Exp1:

max(total<regione>abianti)

exp2:

max(total<facia>abianti)

Regards

rubenmarin — Tue, 26 Jul 2016 08:38:33 GMT

Hi clovati, can you try this?:

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

MayilVahanan — Tue, 26 Jul 2016 08:44:27 GMT

Try like this

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

ashwanin — Tue, 26 Jul 2016 09:19:51 GMT

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

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