topic Above Function in QlikView https://community.qlik.com/t5/QlikView/Above-Function/m-p/477344#M550968 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a question regarding the Above Function. I want to calculate the difference between the current line and the previous one.</P><P>I expect the result to be as in this Excel Table</P><P><IMG alt="Above.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/49416_Above.png" /></P><P></P><P>I simply can't get it to work. The problem I think is the rowno starts again at 1, because there are 2 different years (2012,2013)</P><P>Does anybody have an idea how to solve this?</P><P></P><P>Cheers,</P><P>Fabian</P></BODY></HTML> Fri, 22 Nov 2013 08:04:05 GMT fheidenstecker 2013-11-22T08:04:05Z Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/477344#M550968 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a question regarding the Above Function. I want to calculate the difference between the current line and the previous one.</P><P>I expect the result to be as in this Excel Table</P><P><IMG alt="Above.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/49416_Above.png" /></P><P></P><P>I simply can't get it to work. The problem I think is the rowno starts again at 1, because there are 2 different years (2012,2013)</P><P>Does anybody have an idea how to solve this?</P><P></P><P>Cheers,</P><P>Fabian</P></BODY></HTML> Fri, 22 Nov 2013 08:04:05 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/477344#M550968 fheidenstecker 2013-11-22T08:04:05Z Re: Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/477345#M550969 <HTML><HEAD></HEAD><BODY><P>Try with the TOTAL qualifier:</P><P></P><P>sum(Betrag)- above(TOTAL sum( Betrag ))</P></BODY></HTML> Fri, 22 Nov 2013 08:07:23 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/477345#M550969 swuehl 2013-11-22T08:07:23Z Re: Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/477346#M550970 <HTML><HEAD></HEAD><BODY><P>try this</P><P>sum( Sales )&nbsp; - above( sum( Sales ))</P><P></P><P>or this one</P><P></P><P>above( sum( Sales )) - sum( Sales )&nbsp; </P></BODY></HTML> Fri, 22 Nov 2013 08:11:34 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/477346#M550970 2013-11-22T08:11:34Z Re: Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/477347#M550971 <HTML><HEAD></HEAD><BODY><P>PFA.</P><P>Hope it helps!</P></BODY></HTML> Fri, 22 Nov 2013 08:12:40 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/477347#M550971 2013-11-22T08:12:40Z Re: Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/477348#M550972 <HTML><HEAD></HEAD><BODY><P>Thats was FAST!</P><P>Thanks <A href="https://community.qlik.com/qlik-users/15823">swuehl</A> and <A href="https://community.qlik.com/qlik-users/43319">Shyamal Pandit</A></P></BODY></HTML> Fri, 22 Nov 2013 08:15:23 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/477348#M550972 fheidenstecker 2013-11-22T08:15:23Z Re: Above Function https://community.qlik.com/t5/QlikView/Above-Function/m-p/477349#M550973 <HTML><HEAD></HEAD><BODY><P>See the attached file</P></BODY></HTML> Fri, 22 Nov 2013 08:15:30 GMT https://community.qlik.com/t5/QlikView/Above-Function/m-p/477349#M550973 er_mohit 2013-11-22T08:15:30Z