topic Show difference month by month in QlikView https://community.qlik.com/t5/QlikView/Show-difference-month-by-month/m-p/347262#M493644 <HTML><HEAD></HEAD><BODY><P>I found a solution. Not sure it is the best one, but it solves my problem.</P><P></P><P>=rangesum(above(column(1),1,(RowNo()-1)))//+ column(1)</P><P>-rangesum(above(column(1),0,(RowNo()-1)))//+ column(1)</P></BODY></HTML> Fri, 11 May 2012 12:15:29 GMT Anonymous 2012-05-11T12:15:29Z Show difference month by month https://community.qlik.com/t5/QlikView/Show-difference-month-by-month/m-p/347261#M493643 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a table that I want to look like this</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Area 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Area 2</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp; Change&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp; Change</P><P>201201&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>201202&nbsp;&nbsp;&nbsp;&nbsp; 18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -2</P><P>201203&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>..</P><P></P><P>My problem is the Change column. I nned it to show the cahnge form an period to the next</P><P>I found one forumla, but that adds the changes</P><P></P><P>=rangesum(above(column(1),1,(RowNo()-1)))//+ column(1)</P><P></P><P>How can I get the Change column to simply show the difference between from one period to another?</P><P></P><P>BR</P><P>Dan</P></BODY></HTML> Fri, 11 May 2012 11:48:06 GMT https://community.qlik.com/t5/QlikView/Show-difference-month-by-month/m-p/347261#M493643 Anonymous 2012-05-11T11:48:06Z Show difference month by month https://community.qlik.com/t5/QlikView/Show-difference-month-by-month/m-p/347262#M493644 <HTML><HEAD></HEAD><BODY><P>I found a solution. Not sure it is the best one, but it solves my problem.</P><P></P><P>=rangesum(above(column(1),1,(RowNo()-1)))//+ column(1)</P><P>-rangesum(above(column(1),0,(RowNo()-1)))//+ column(1)</P></BODY></HTML> Fri, 11 May 2012 12:15:29 GMT https://community.qlik.com/t5/QlikView/Show-difference-month-by-month/m-p/347262#M493644 Anonymous 2012-05-11T12:15:29Z