Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Contributor III
Contributor III

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.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

RangeMax(

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

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

)


-Rob