topic Re: Get previous months values in qlikview scripting in QlikView

topic Re: Get previous months values in qlikview scripting in QlikView https://community.qlik.com/t5/QlikView/Get-previous-months-values-in-qlikview-scripting/m-p/1122988#M632327 <HTML><HEAD></HEAD><BODY><P>Look here:</P><P><A href="https://community.qlik.com/qlik-blogpost/2928">How to populate a sparsely populated field</A></P></BODY></HTML> Wed, 03 Aug 2016 15:25:53 GMT sunny_talwar 2016-08-03T15:25:53Z Get previous months values in qlikview scripting https://community.qlik.com/t5/QlikView/Get-previous-months-values-in-qlikview-scripting/m-p/1122987#M632326 <HTML><HEAD></HEAD><BODY><P>I have a scenario where i have location monthname and the measure value. I need to develop the qlikview report in such a way that i should get the measure value for each location for each month.</P><P>If there is no value associated for a month for a location i should pickup the latest measure value for the latest month prior to missing month. It need not be the previous month. </P><P></P><P>Below is the example of the scenario. Can any one suggest me </P><P></P><P>  </P><TABLE border="0" cellpadding="0" cellspacing="0" width="512"><TBODY><TR><TD class="xl67" colspan="3" height="20" style="border-right: .5pt solid black;" width="192">Actual Value</TD><TD width="64"></TD><TD width="64"></TD><TD class="xl67" colspan="3" style="border-right: .5pt solid black;" width="192">Expected Value</TD></TR><TR><TD class="xl70" height="20" style="border-top: none;">Location</TD><TD class="xl70" style="border-top: none; border-left: none;">Month</TD><TD class="xl70" style="border-top: none; border-left: none;">Value</TD><TD></TD><TD></TD><TD class="xl70" style="border-top: none;">Location</TD><TD class="xl70" style="border-top: none; border-left: none;">Month</TD><TD class="xl70" style="border-top: none; border-left: none;">Value</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Jan-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100</TD><TD></TD><TD></TD><TD class="xl65" style="border-top: none;">A</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">Jan-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Feb-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">200</TD><TD></TD><TD></TD><TD class="xl65" style="border-top: none;">A</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">Feb-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">200</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">May-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">400</TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Mar-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">200</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Aug-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100</TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Apr-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">200</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Jan-16</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD><TD></TD><TD></TD><TD class="xl65" style="border-top: none;">A</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">May-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">400</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Apr-16</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">200</TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Jun-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">400</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Jun-16</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">400</TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Jul-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">400</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl65" style="border-top: none;">A</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">Aug-15</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">100</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Sep-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Oct-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Nov-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Dec-15</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">100</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl65" style="border-top: none;">A</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">Jan-16</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">300</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Feb-16</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">Mar-16</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">300</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl65" style="border-top: none;">A</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">Apr-16</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">200</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl63" style="border-top: none;">A</TD><TD align="right" class="xl64" style="border-top: none; border-left: none;">May-16</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">200</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD class="xl65" style="border-top: none;">A</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">Jun-16</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">400</TD></TR><TR><TD height="20"></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 03 Aug 2016 14:49:07 GMT https://community.qlik.com/t5/QlikView/Get-previous-months-values-in-qlikview-scripting/m-p/1122987#M632326 2016-08-03T14:49:07Z Re: Get previous months values in qlikview scripting https://community.qlik.com/t5/QlikView/Get-previous-months-values-in-qlikview-scripting/m-p/1122988#M632327 <HTML><HEAD></HEAD><BODY><P>Look here:</P><P><A href="https://community.qlik.com/qlik-blogpost/2928">How to populate a sparsely populated field</A></P></BODY></HTML> Wed, 03 Aug 2016 15:25:53 GMT https://community.qlik.com/t5/QlikView/Get-previous-months-values-in-qlikview-scripting/m-p/1122988#M632327 sunny_talwar 2016-08-03T15:25:53Z