topic Add missing months in script with previous value (amount) in QlikView https://community.qlik.com/t5/QlikView/Add-missing-months-in-script-with-previous-value-amount/m-p/1028266#M347340 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>Can somebody help me with a loadscript to solve the problem as described in the attachment.</P><P>I have to add missing months with the amount value of the previous record (row).</P><P></P><P>The 'Source' is my real source (resident) and the 'Solution' is how to end up after some scripting at wich i need help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>Thanks in advance anyone!</P><P></P><P>Bart</P><P></P><P>P.S. I changed the attachment, there was an error in it.</P><DIV style="display: none;"> </DIV><DIV style="display: none;"> </DIV></BODY></HTML> Tue, 05 Jan 2016 20:43:21 GMT bartvanwetten 2016-01-05T20:43:21Z Add missing months in script with previous value (amount) https://community.qlik.com/t5/QlikView/Add-missing-months-in-script-with-previous-value-amount/m-p/1028266#M347340 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>Can somebody help me with a loadscript to solve the problem as described in the attachment.</P><P>I have to add missing months with the amount value of the previous record (row).</P><P></P><P>The 'Source' is my real source (resident) and the 'Solution' is how to end up after some scripting at wich i need help <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>Thanks in advance anyone!</P><P></P><P>Bart</P><P></P><P>P.S. I changed the attachment, there was an error in it.</P><DIV style="display: none;"> </DIV><DIV style="display: none;"> </DIV></BODY></HTML> Tue, 05 Jan 2016 20:43:21 GMT https://community.qlik.com/t5/QlikView/Add-missing-months-in-script-with-previous-value-amount/m-p/1028266#M347340 bartvanwetten 2016-01-05T20:43:21Z Re: Add missing months in script with previous value (amount) https://community.qlik.com/t5/QlikView/Add-missing-months-in-script-with-previous-value-amount/m-p/1028267#M347341 <HTML><HEAD></HEAD><BODY><P>PFA</P><P></P><P>"<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">P.S. I changed the attachment, there was an error in it.</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">"</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; line-height: 1.5em;">Just reload with new excel data<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Tue, 05 Jan 2016 21:25:19 GMT https://community.qlik.com/t5/QlikView/Add-missing-months-in-script-with-previous-value-amount/m-p/1028267#M347341 maxgro 2016-01-05T21:25:19Z Re: Add missing months in script with previous value (amount) https://community.qlik.com/t5/QlikView/Add-missing-months-in-script-with-previous-value-amount/m-p/1028268#M347342 <HTML><HEAD></HEAD><BODY><P>Hi Max,</P><P></P><P>Bullseye!. You made my day!</P><P></P><P>Many regards,</P><P></P><P>Bart</P></BODY></HTML> Tue, 05 Jan 2016 21:37:00 GMT https://community.qlik.com/t5/QlikView/Add-missing-months-in-script-with-previous-value-amount/m-p/1028268#M347342 bartvanwetten 2016-01-05T21:37:00Z