Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Catch up on the newest Qlik features and improvements: Learn More
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?

Labels (1)
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
MVP
MVP

RangeMax(

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

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

)


-Rob