topic Cumulative to Non-Cumulative in QlikView https://community.qlik.com/t5/QlikView/Cumulative-to-Non-Cumulative/m-p/867369#M656032 <HTML><HEAD></HEAD><BODY><P>Please note that database contains cumulative figure, however I wish to load the figure non-cumulative form. For eg, in Jan, revenue is 100, in Feb, it is&nbsp; 210 which cotains Jan Figure also. I wish to load 110 as Feb Revenue instead of 210. Please provide script which can be used to create non-cumulative figure while laoding.</P></BODY></HTML> Thu, 28 May 2015 07:59:40 GMT 2015-05-28T07:59:40Z Cumulative to Non-Cumulative https://community.qlik.com/t5/QlikView/Cumulative-to-Non-Cumulative/m-p/867369#M656032 <HTML><HEAD></HEAD><BODY><P>Please note that database contains cumulative figure, however I wish to load the figure non-cumulative form. For eg, in Jan, revenue is 100, in Feb, it is&nbsp; 210 which cotains Jan Figure also. I wish to load 110 as Feb Revenue instead of 210. Please provide script which can be used to create non-cumulative figure while laoding.</P></BODY></HTML> Thu, 28 May 2015 07:59:40 GMT https://community.qlik.com/t5/QlikView/Cumulative-to-Non-Cumulative/m-p/867369#M656032 2015-05-28T07:59:40Z Re: Cumulative to Non-Cumulative https://community.qlik.com/t5/QlikView/Cumulative-to-Non-Cumulative/m-p/867370#M656033 <HTML><HEAD></HEAD><BODY><P>Within a sorted (resident) load you could with the functions peek() or previous() access the previous rows and therefore calculate the difference between them - see to how it worked to this example: <A href="https://community.qlik.com/qlik-blogpost/3048">Peek() vs Previous() – When to Use Each</A>.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 28 May 2015 20:25:31 GMT https://community.qlik.com/t5/QlikView/Cumulative-to-Non-Cumulative/m-p/867370#M656033 marcus_sommer 2015-05-28T20:25:31Z