topic Re: How to get the difference of two row values of the same table? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-difference-of-two-row-values-of-the-same-table/m-p/749232#M267337 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I think it's better to do it in the script. See attached file.</P></BODY></HTML> Thu, 05 Feb 2015 13:48:17 GMT 2015-02-05T13:48:17Z How to get the difference of two row values of the same table? https://community.qlik.com/t5/QlikView/How-to-get-the-difference-of-two-row-values-of-the-same-table/m-p/749230#M267335 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>i need some help..</P><P></P><P><SPAN style="text-decoration: underline;">table1:</SPAN></P><P>value</P><P> 23</P><P> 34</P><P> 56</P><P> 67</P><P>i need the output to be in follwing manner.</P><P></P><P>output:</P><P>value&nbsp;&nbsp;&nbsp;&nbsp; variation</P><P>23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11<BR />34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22</P><P>56&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12</P><P>68&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 68</P></BODY></HTML> Thu, 05 Feb 2015 11:24:45 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-difference-of-two-row-values-of-the-same-table/m-p/749230#M267335 2015-02-05T11:24:45Z Re: How to get the difference of two row values of the same table? https://community.qlik.com/t5/QlikView/How-to-get-the-difference-of-two-row-values-of-the-same-table/m-p/749231#M267336 <HTML><HEAD></HEAD><BODY><P>this is my example</P></BODY></HTML> Thu, 05 Feb 2015 11:30:44 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-difference-of-two-row-values-of-the-same-table/m-p/749231#M267336 alexandros17 2015-02-05T11:30:44Z Re: How to get the difference of two row values of the same table? https://community.qlik.com/t5/QlikView/How-to-get-the-difference-of-two-row-values-of-the-same-table/m-p/749232#M267337 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I think it's better to do it in the script. See attached file.</P></BODY></HTML> Thu, 05 Feb 2015 13:48:17 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-difference-of-two-row-values-of-the-same-table/m-p/749232#M267337 2015-02-05T13:48:17Z Re: How to get the difference of two row values of the same table? https://community.qlik.com/t5/QlikView/How-to-get-the-difference-of-two-row-values-of-the-same-table/m-p/749233#M267338 <HTML><HEAD></HEAD><BODY><P>Hi Saugat,</P><P>The <EM><STRONG>above function</STRONG></EM> will do the needful.</P><P></P><P>Please check Henric blog post: <A href="https://community.qlik.com/qlik-blogpost/4522">The Above Function</A></P><P></P><P>Regards,</P><P>Ankur</P></BODY></HTML> Tue, 19 Jul 2016 12:31:00 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-difference-of-two-row-values-of-the-same-table/m-p/749233#M267338 ankurakash 2016-07-19T12:31:00Z