topic Re: How to get a max value in QlikView

How to get a max value

Thu, 05 Nov 2015 11:37:46 GMT

Hi All,

From below table I only want to show the max value of Procedure as a single row in a straight table.

HRG	Procedure	PD	Amount
BMT_AlloRel	Diagnosis - ZZZ	EL	£29,363
BMT_AlloRel	X336-Allogeneic	EL	£299,320
BMT_AlloRel	X711-PROCUREMENT	EL	£32,544
Total			£361,228

Expected output:

BMT_AlloRel

X336-Allogeneic

£299,320

Thanks

Re: How to get a max value

Anonymous — Thu, 05 Nov 2015 12:42:01 GMT

use expression

=aggr(max(PD Amount),HRG)

this should do

Re: How to get a max value

tresB — Thu, 05 Nov 2015 12:56:24 GMT

Dimension: HRG

Exp1: FirstSortedValue(Procedure, -[PD Amount])

Exp2: FirstSortedValue(PD, -[PD Amount])

Exp3: Max([PD Amount])

While there would be multiple data points against each combination, you might have to use sum() along with max() and firstsortedvalue() and yes aggr() would be required there.

Re: How to get a max value

Anonymous — Thu, 05 Nov 2015 13:01:29 GMT

What about this one:

=max( {total HRG} [PD Amount])