Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Valued Contributor

how to write max yoy value expression in a textbox

How All,

                  I have to display max YOY increase value

Untitled.png

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


22 Replies

Re: how to write max yoy value expression in a textbox

Above doesn't work in the text box ..that is the issue

kunkumnaveen
Valued Contributor

Re: how to write max yoy value expression in a textbox

any alternative expression to get max yoy value

Partner
Partner

Re: how to write max yoy value expression in a textbox

Hi Naveen,

Can you share your QVW?

kunkumnaveen
Valued Contributor

Re: how to write max yoy value expression in a textbox

PFA qvw file

kunkumnaveen
Valued Contributor

Re: how to write max yoy value expression in a textbox

i have attach the file

kunkumnaveen
Valued Contributor

Re: how to write max yoy value expression in a textbox

Any help in writing the epression plz

prma7799
Honored Contributor III

Re: how to write max yoy value expression in a textbox

Please try like this in your text object

=Num(( sum({<year = {$(=max(year))} >}value) - sum({<year = {$(=max(year)-1)} >}value)) / (sum({<year = {$(=max(year)-1)} >}value))*100,'#.##')

Re: how to write max yoy value expression in a textbox

check the attachment

kunkumnaveen
Valued Contributor

Re: how to write max yoy value expression in a textbox

Thanks for your reply ,

it looks like ,that your expression  will alway take max year value only ,for the above example it gives exact output

but  in case if  YOY  value of 2015 is more then  2016 value still your expression will show 2016 value even though it has to be 2015 value ....