topic YTD and rolling 12 months problem in QlikView https://community.qlik.com/t5/QlikView/YTD-and-rolling-12-months-problem/m-p/259900#M581647 <HTML><HEAD></HEAD><BODY><P>Hi Dear QlikCommunity</P><P></P><P><SPAN id="result_box" lang="en"><SPAN class="hps">I have</SPAN> <SPAN class="hps">a problem</SPAN>, I need a <SPAN class="hps">pivot table</SPAN> <SPAN class="hps">in which</SPAN> <SPAN class="hps">indicators</SPAN> <SPAN class="hps">are displayed</SPAN> <SPAN class="hps">on a</SPAN> <SPAN class="hps">rolling</SPAN> <SPAN class="hps">12 months,</SPAN> <SPAN class="hps">these indicators</SPAN> <SPAN class="hps">are formed by</SPAN> <SPAN class="hps">summing</SPAN> <SPAN class="hps">all, in</SPAN> <SPAN class="hps">the fact table</SPAN> <SPAN class="hps">is registered</SPAN> <SPAN class="hps">daily</SPAN> <SPAN class="hps">values ​​for</SPAN> <SPAN class="hps">each of</SPAN> <SPAN class="hps">those accounts.</SPAN></SPAN></P><P><SPAN id="result_box" lang="en"><SPAN class="hps"> </SPAN><BR /> <SPAN class="hps">I need</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">monthly</SPAN> <SPAN class="hps">value</SPAN> <SPAN class="hps">recorded in</SPAN> <SPAN class="hps atn">each period (</SPAN>Month <SPAN class="hps">- Year)</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">YTD</SPAN> <SPAN class="hps">up to that</SPAN> <SPAN class="hps">period.</SPAN><BR /> <SPAN class="hps">What I'm</SPAN> <SPAN class="hps">trying to do is</SPAN> <SPAN class="hps">calculate</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">YTD</SPAN> <SPAN class="hps">loads the</SPAN> <SPAN class="hps">script</SPAN> <SPAN class="hps">but I got no</SPAN> <SPAN class="hps">success</SPAN>, for n <SPAN class="hps">the</SPAN> <SPAN class="hps">front end</SPAN> <SPAN class="hps">to implement the</SPAN> <SPAN class="hps">rolling</SPAN> <SPAN class="hps">12 months</SPAN>.<BR /><BR /> <SPAN class="hps">Any suggestions,</SPAN> <SPAN class="hps">to calculate the</SPAN> <SPAN class="hps">YTD</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">upload script</SPAN>?</SPAN></P></BODY></HTML> Mon, 28 Nov 2011 13:34:29 GMT 2011-11-28T13:34:29Z YTD and rolling 12 months problem https://community.qlik.com/t5/QlikView/YTD-and-rolling-12-months-problem/m-p/259900#M581647 <HTML><HEAD></HEAD><BODY><P>Hi Dear QlikCommunity</P><P></P><P><SPAN id="result_box" lang="en"><SPAN class="hps">I have</SPAN> <SPAN class="hps">a problem</SPAN>, I need a <SPAN class="hps">pivot table</SPAN> <SPAN class="hps">in which</SPAN> <SPAN class="hps">indicators</SPAN> <SPAN class="hps">are displayed</SPAN> <SPAN class="hps">on a</SPAN> <SPAN class="hps">rolling</SPAN> <SPAN class="hps">12 months,</SPAN> <SPAN class="hps">these indicators</SPAN> <SPAN class="hps">are formed by</SPAN> <SPAN class="hps">summing</SPAN> <SPAN class="hps">all, in</SPAN> <SPAN class="hps">the fact table</SPAN> <SPAN class="hps">is registered</SPAN> <SPAN class="hps">daily</SPAN> <SPAN class="hps">values ​​for</SPAN> <SPAN class="hps">each of</SPAN> <SPAN class="hps">those accounts.</SPAN></SPAN></P><P><SPAN id="result_box" lang="en"><SPAN class="hps"> </SPAN><BR /> <SPAN class="hps">I need</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">monthly</SPAN> <SPAN class="hps">value</SPAN> <SPAN class="hps">recorded in</SPAN> <SPAN class="hps atn">each period (</SPAN>Month <SPAN class="hps">- Year)</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">YTD</SPAN> <SPAN class="hps">up to that</SPAN> <SPAN class="hps">period.</SPAN><BR /> <SPAN class="hps">What I'm</SPAN> <SPAN class="hps">trying to do is</SPAN> <SPAN class="hps">calculate</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">YTD</SPAN> <SPAN class="hps">loads the</SPAN> <SPAN class="hps">script</SPAN> <SPAN class="hps">but I got no</SPAN> <SPAN class="hps">success</SPAN>, for n <SPAN class="hps">the</SPAN> <SPAN class="hps">front end</SPAN> <SPAN class="hps">to implement the</SPAN> <SPAN class="hps">rolling</SPAN> <SPAN class="hps">12 months</SPAN>.<BR /><BR /> <SPAN class="hps">Any suggestions,</SPAN> <SPAN class="hps">to calculate the</SPAN> <SPAN class="hps">YTD</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">upload script</SPAN>?</SPAN></P></BODY></HTML> Mon, 28 Nov 2011 13:34:29 GMT https://community.qlik.com/t5/QlikView/YTD-and-rolling-12-months-problem/m-p/259900#M581647 2011-11-28T13:34:29Z