topic Re: what is year over year? in QlikView https://community.qlik.com/t5/QlikView/what-is-year-over-year/m-p/40730#M789107 <HTML><HEAD></HEAD><BODY><P>This means how much you progress in current year than previous year</P><P>like (sales of 2018 - sales of 2017)/sales of 2017</P><P></P><P>expression would be like </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=((sum({$&lt;Year = {$(=max(Year))}&gt;}Sales) - sum({$&lt;Year ={$(=max(Year)-1)}&gt;}Sales))/ sum({$&lt;Year = {$(=max(Year)-1)}&gt;}Sales)) * 100</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Are you looking for this?<BR /></SPAN></P></BODY></HTML> Sat, 17 Feb 2018 03:15:35 GMT shiveshsingh 2018-02-17T03:15:35Z what is year over year? https://community.qlik.com/t5/QlikView/what-is-year-over-year/m-p/40729#M789106 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>what is year over year.and what is the use of this and write the set expressions.</P><P></P><P></P><P>Thanks</P><P>Chaitanya</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/what-is-year-over-year/m-p/40729#M789106 gkcchowdary 2020-11-25T16:16:04Z Re: what is year over year? https://community.qlik.com/t5/QlikView/what-is-year-over-year/m-p/40730#M789107 <HTML><HEAD></HEAD><BODY><P>This means how much you progress in current year than previous year</P><P>like (sales of 2018 - sales of 2017)/sales of 2017</P><P></P><P>expression would be like </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=((sum({$&lt;Year = {$(=max(Year))}&gt;}Sales) - sum({$&lt;Year ={$(=max(Year)-1)}&gt;}Sales))/ sum({$&lt;Year = {$(=max(Year)-1)}&gt;}Sales)) * 100</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Are you looking for this?<BR /></SPAN></P></BODY></HTML> Sat, 17 Feb 2018 03:15:35 GMT https://community.qlik.com/t5/QlikView/what-is-year-over-year/m-p/40730#M789107 shiveshsingh 2018-02-17T03:15:35Z