topic Re: YTD portion calculation (in script) for cost allocation in QlikView https://community.qlik.com/t5/QlikView/YTD-portion-calculation-in-script-for-cost-allocation/m-p/1269174#M856430 <HTML><HEAD></HEAD><BODY><P>Sorted this, finally !</P></BODY></HTML> Mon, 13 Feb 2017 23:25:16 GMT Anonymous 2017-02-13T23:25:16Z YTD portion calculation (in script) for cost allocation https://community.qlik.com/t5/QlikView/YTD-portion-calculation-in-script-for-cost-allocation/m-p/1269173#M856429 <HTML><HEAD></HEAD><BODY><P>Hi Community</P><P>After a couple of days without success I have decided to wave the white flag and ask for help. I have calculate the monthly YTD portion for each record in my table. My aim is to allocate a monthly expense balance based on the YTD portion calculated for each transaction/record in the table below and I want to do this in the script. The result should be as below. I am struggling to achieve this in Qlik.&nbsp; I can get to the YTD portion by customer by month but the problem is that that doesn't add to a integer as the previous months drop off. I think the only way to avoid this is to have a YTD portion for each month in a separate field as below.&nbsp; I wonder if the "peek" or "previous" functions could achieve this? Any feedback will be appreciated. App attached. !</P><P></P><P><IMG __jive_id="151526" alt="Excel.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/151526_Excel.png" style="height: 271px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/YTD-portion-calculation-in-script-for-cost-allocation/m-p/1269173#M856429 Anonymous 2020-11-25T16:16:04Z Re: YTD portion calculation (in script) for cost allocation https://community.qlik.com/t5/QlikView/YTD-portion-calculation-in-script-for-cost-allocation/m-p/1269174#M856430 <HTML><HEAD></HEAD><BODY><P>Sorted this, finally !</P></BODY></HTML> Mon, 13 Feb 2017 23:25:16 GMT https://community.qlik.com/t5/QlikView/YTD-portion-calculation-in-script-for-cost-allocation/m-p/1269174#M856430 Anonymous 2017-02-13T23:25:16Z