topic Re: Calculation on Other Row Value by Script in QlikView https://community.qlik.com/t5/QlikView/Solved/m-p/1009311#M973250 <HTML><HEAD></HEAD><BODY><P>You could do it like this:</P><P></P><P>Trans:</P><P>LOAD Date#(PERIOD, 'YYYYMM') As PERIOD,</P><P>&nbsp; SALES</P><P>Inline</P><P>[</P><P>&nbsp; PERIOD, SALES</P><P>&nbsp; 201312, 264</P><P>&nbsp; 201401, 675</P><P>&nbsp; 201402, 235</P><P>&nbsp; 201403, 236</P><P>&nbsp; 201404, 124</P><P>&nbsp; 201405, 672</P><P>&nbsp; 201406, 643</P><P>&nbsp; 201407, 124</P><P>&nbsp; 201408, 643</P><P>&nbsp; 201409, 252</P><P>&nbsp; 201410, 257</P><P>&nbsp; 201411, 743</P><P>&nbsp; 201412, 257</P><P>&nbsp; 201501, 723</P><P>&nbsp; 201502, 245</P><P>];</P><P></P><P>Join (Trans)</P><P>LOAD PERIOD,</P><P>&nbsp; If(Month(PERIOD) = 1, PREVIOUS(SALES), Alt(Peek(PYSALES), SALES)) As PYSALES</P><P>Resident Trans</P><P>ORDER BY PERIOD;</P><P></P><P>Join (Trans)</P><P>LOAD PERIOD,</P><P>&nbsp; SALES / PYSALES As INDEX</P><P>Resident Trans;</P><P></P><P>(Change INLINE to a load from your correct data source)</P><P></P><P><IMG alt="t1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98475_t1.png" style="height: auto;" /></P></BODY></HTML> Thu, 10 Sep 2015 06:00:50 GMT jonathandienst 2015-09-10T06:00:50Z Solved https://community.qlik.com/t5/QlikView/Solved/m-p/1009310#M973248 <HTML><HEAD></HEAD><BODY><P>Solved</P></BODY></HTML> Thu, 10 Sep 2015 05:40:24 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1009310#M973248 microwin88x 2015-09-10T05:40:24Z Re: Calculation on Other Row Value by Script https://community.qlik.com/t5/QlikView/Solved/m-p/1009311#M973250 <HTML><HEAD></HEAD><BODY><P>You could do it like this:</P><P></P><P>Trans:</P><P>LOAD Date#(PERIOD, 'YYYYMM') As PERIOD,</P><P>&nbsp; SALES</P><P>Inline</P><P>[</P><P>&nbsp; PERIOD, SALES</P><P>&nbsp; 201312, 264</P><P>&nbsp; 201401, 675</P><P>&nbsp; 201402, 235</P><P>&nbsp; 201403, 236</P><P>&nbsp; 201404, 124</P><P>&nbsp; 201405, 672</P><P>&nbsp; 201406, 643</P><P>&nbsp; 201407, 124</P><P>&nbsp; 201408, 643</P><P>&nbsp; 201409, 252</P><P>&nbsp; 201410, 257</P><P>&nbsp; 201411, 743</P><P>&nbsp; 201412, 257</P><P>&nbsp; 201501, 723</P><P>&nbsp; 201502, 245</P><P>];</P><P></P><P>Join (Trans)</P><P>LOAD PERIOD,</P><P>&nbsp; If(Month(PERIOD) = 1, PREVIOUS(SALES), Alt(Peek(PYSALES), SALES)) As PYSALES</P><P>Resident Trans</P><P>ORDER BY PERIOD;</P><P></P><P>Join (Trans)</P><P>LOAD PERIOD,</P><P>&nbsp; SALES / PYSALES As INDEX</P><P>Resident Trans;</P><P></P><P>(Change INLINE to a load from your correct data source)</P><P></P><P><IMG alt="t1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/98475_t1.png" style="height: auto;" /></P></BODY></HTML> Thu, 10 Sep 2015 06:00:50 GMT https://community.qlik.com/t5/QlikView/Solved/m-p/1009311#M973250 jonathandienst 2015-09-10T06:00:50Z