QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Maximum Calculated Fields

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?

2 Replies
New Contributor III

Re: Maximum Calculated Fields

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.

MVP

Re: Maximum Calculated Fields

RangeMax(

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

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

)

-Rob