https://community.qlik.com/t5/QlikView/Fill-up-last-value-in-pivot-chart/m-p/1634547#M446693 <P>Hi,</P><P>I hope someone has an idea, how to solve my problem.</P><P>I have a pivot chart, where I try to calculate an rolling average of the last 3 month - Row Test:</P><P>Sum(Aggr(Rangesum(Above(Sum(Repair_Cost_Total), 0, 3)), Monthyear))<BR />+ Sum(Aggr(Rangesum(Above(sum( {&lt;Warranty_Field=, Quality_Field=, Delete_Field=&gt;} Return_Credit_Amount), 0, 3)), Monthyear))</P><P>This works fine!<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pivot" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21348i07D974F1E6EC6A5B/image-size/large?v=v2&amp;px=999" role="button" title="2019-10-13 08_06_08-Clipboard.png" alt="Pivot" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Pivot</span></span></P><P>Now, I would like to continue the last entry of Test, for all upcoming months.<BR />I want to fill in the 680.151,46 in all right fields, where it is 0,00 now.</P><P>Anyone has an idea, how I can do this?</P><P>Best regards<BR />Tom</P> Sat, 16 Nov 2024 19:54:39 GMT tombombadil 2024-11-16T19:54:39Z https://community.qlik.com/t5/QlikView/Fill-up-last-value-in-pivot-chart/m-p/1634547#M446693 <P>Hi,</P><P>I hope someone has an idea, how to solve my problem.</P><P>I have a pivot chart, where I try to calculate an rolling average of the last 3 month - Row Test:</P><P>Sum(Aggr(Rangesum(Above(Sum(Repair_Cost_Total), 0, 3)), Monthyear))<BR />+ Sum(Aggr(Rangesum(Above(sum( {&lt;Warranty_Field=, Quality_Field=, Delete_Field=&gt;} Return_Credit_Amount), 0, 3)), Monthyear))</P><P>This works fine!<BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pivot" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/21348i07D974F1E6EC6A5B/image-size/large?v=v2&amp;px=999" role="button" title="2019-10-13 08_06_08-Clipboard.png" alt="Pivot" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Pivot</span></span></P><P>Now, I would like to continue the last entry of Test, for all upcoming months.<BR />I want to fill in the 680.151,46 in all right fields, where it is 0,00 now.</P><P>Anyone has an idea, how I can do this?</P><P>Best regards<BR />Tom</P> Sat, 16 Nov 2024 19:54:39 GMT https://community.qlik.com/t5/QlikView/Fill-up-last-value-in-pivot-chart/m-p/1634547#M446693 tombombadil 2024-11-16T19:54:39Z https://community.qlik.com/t5/QlikView/Fill-up-last-value-in-pivot-chart/m-p/1637973#M446972 <P>Tom, quite a few historical posts on this topic, hopefully one of the following links will get you what you need...</P> <P><A href="https://community.qlik.com/t5/QlikView-App-Development/6-month-rolling-forecast/m-p/1273774#M400346" target="_blank">https://community.qlik.com/t5/QlikView-App-Development/6-month-rolling-forecast/m-p/1273774#M400346</A></P> <P>That is likely the most relevant one I think, if that does not work, feel free to search within the QlikView forum for the other posts related to 'forecasts' to see if any of those may help too.</P> <P>Regards,<BR />Brett</P> Mon, 21 Oct 2019 17:21:13 GMT https://community.qlik.com/t5/QlikView/Fill-up-last-value-in-pivot-chart/m-p/1637973#M446972 Brett_Bleess 2019-10-21T17:21:13Z