https://community.qlik.com/t5/QlikView/Access-Data-in-Previous-Row-Straight-Table/m-p/636158#M233320 <HTML><HEAD></HEAD><BODY><P>did you explore chart inter record functions?</P></BODY></HTML> Fri, 16 May 2014 15:28:19 GMT 2014-05-16T15:28:19Z https://community.qlik.com/t5/QlikView/Access-Data-in-Previous-Row-Straight-Table/m-p/636157#M233319 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'd like to create a year-over-year variance calculation. I have a table with yearly spend and spend per resource. I'd like to calculate the variance of the current year's spend per resource ("Per Atty" below) to the previous year's. I think I can do this with use of the TOTAL function and a set analysis expression, but is there an easy way just to access the data from an adjacent row?</P><P><IMG alt="Capture.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/58983_Capture.PNG.png" /></P></BODY></HTML> Fri, 16 May 2014 15:20:31 GMT https://community.qlik.com/t5/QlikView/Access-Data-in-Previous-Row-Straight-Table/m-p/636157#M233319 2014-05-16T15:20:31Z https://community.qlik.com/t5/QlikView/Access-Data-in-Previous-Row-Straight-Table/m-p/636158#M233320 <HTML><HEAD></HEAD><BODY><P>did you explore chart inter record functions?</P></BODY></HTML> Fri, 16 May 2014 15:28:19 GMT https://community.qlik.com/t5/QlikView/Access-Data-in-Previous-Row-Straight-Table/m-p/636158#M233320 2014-05-16T15:28:19Z https://community.qlik.com/t5/QlikView/Access-Data-in-Previous-Row-Straight-Table/m-p/636159#M233321 <HTML><HEAD></HEAD><BODY><P>Use above() function </P><P></P><P>above(Spend)</P><P></P><P></P><P>hope this helps</P></BODY></HTML> Fri, 16 May 2014 15:31:49 GMT https://community.qlik.com/t5/QlikView/Access-Data-in-Previous-Row-Straight-Table/m-p/636159#M233321 SunilChauhan 2014-05-16T15:31:49Z https://community.qlik.com/t5/QlikView/Access-Data-in-Previous-Row-Straight-Table/m-p/636160#M233322 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Fri, 16 May 2014 16:21:57 GMT https://community.qlik.com/t5/QlikView/Access-Data-in-Previous-Row-Straight-Table/m-p/636160#M233322 2014-05-16T16:21:57Z