how to write max yoy value expression in a textbox

[kunkumnaveen]

How All,

                  I have to display max YOY increase value

to get max YOY increase value which is (67%) in 2016 i wrote below expression in text box ,but i am getting -0 value

Expression:  =num(Max(Aggr((Sum(value)-Above(Sum(value)))/Above(Sum(value)), year)),'###0')

some thing is wrong with this expression

can any suggestion plz

thanks

[kunkumnaveen]

i wont be able to copy you Qvw file in to my server due to some security reason ...could you plz send expression

[tresesco]

Qlik Sense 2.2 onwards it is there.

[prma7799]

Like this?

=if( (sum({<year = {$(=max(year)-1)} >}value)) > sum(value)

,

(Num(( sum({<year = {$(=max(year)-1)} >}value) - sum({<year = {$(=max(year)-2)} >}value)) / (sum({<year = {$(=max(year)-2)} >}value)),'#,##0%'))

,if(sum(value) >  (sum({<year = {$(=max(year))} >}value)) ,((Num(( sum({<year = {$(=max(year))} >}value) - sum({<year = {$(=max(year)-1)} >}value)) / (sum({<year = {$(=max(year)-1)} >}value)),'#,##0%')))

))