Qlik Community

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
hcabrera
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.

Re: Maximum Calculated Fields

RangeMax(

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

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

)


-Rob

Community Browser