topic Expression help with Max function. in QlikView

Expression help with Max function.

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

How can I put the below expression in Text Object

I know max(NoOfMonthsCY) is throwing it off..ID is the PK.

=sum(if(StartdateYear = EndtdateYear,ExpenseAmountLocal*NoOfMonthsnew,

if(StartdateYear<=year(today()),

if(EndtdateYear>=year(today()),ExpenseAmountLocal * max(NoOfMonthsCY)))))

Thank you.

sunny_talwar — Wed, 15 Feb 2017 20:09:19 GMT

Not entirely sure of what you doing, but may be this?

=Sum(

Aggr(

If(StartdateYear = EndtdateYear, ExpenseAmountLocal*NoOfMonthsnew,

if(StartdateYear<=year(today()),

If(EndtdateYear>=year(today()), ExpenseAmountLocal * max(NoOfMonthsCY)))), PK))