Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

How to get a max value

Hi All,

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

HRGProcedurePDAmount
BMT_AlloRelDiagnosis - ZZZEL£29,363
BMT_AlloRelX336-AllogeneicEL£299,320
BMT_AlloRelX711-PROCUREMENT EL£32,544
Total£361,228

Expected output:

BMT_AlloRelX336-AllogeneicEL£299,320

Thanks

1 Solution

Accepted Solutions
Partner
Partner

Re: How to get a max value

use expression

=aggr(max(PD Amount),HRG)

this should do

3 Replies
Partner
Partner

Re: How to get a max value

use expression

=aggr(max(PD Amount),HRG)

this should do

MVP
MVP

Re: How to get a max value

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.

balrajahlawat
Esteemed Contributor

Re: How to get a max value

What about this one:

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