topic Re: Maximum Calculated Fields in QlikView

Maximum Calculated Fields

Mon, 26 Jan 2026 18:19:17 GMT

Hello,

I have two calculated fields:

=Sum( {<BMIYEAR={"$(YearNo1)"},BMIWEEKNR={"<=10"}>} BRT)

=Sum( {<BMIYEAR={"$(YearNo2"},BMIWEEKNR={"<=10"}>} BRT )

Now i want to have the maximum value of both.

How do i do this?

Re: Maximum Calculated Fields

hcabrera — Wed, 10 Dec 2014 23:10:09 GMT

Hi Ama,

I do not know if it is as optimal but you can use a pivot table an expression to compare the two calculated fields and determine the largest in the pivot table can be used also as expressions calculated fields.

Saludos,

Henry C.

Re: Maximum Calculated Fields

rwunderlich — Wed, 10 Dec 2014 23:24:24 GMT

RangeMax(

Sum( {<BMIYEAR={"$(YearNo1)"},BMIWEEKNR={"<=10"}>} BRT)

,Sum( {<BMIYEAR={"$(YearNo2"},BMIWEEKNR={"<=10"}>} BRT )

)

-Rob