topic Result based on previous months in QlikView https://community.qlik.com/t5/QlikView/Result-based-on-previous-months/m-p/1266344#M398898 <HTML><HEAD></HEAD><BODY><P>Hi, I'm trying to sum 12 values for each month, based on the "ThisMonth" values of the previous 12 months.</P><P>ThisMonth is just a sum: <SPAN style="font-family: 'courier new', courier;">Sum(InvoiceQuantity)</SPAN></P><P></P><P>And for the sake of this demo, I've been able to calculate "Prev Months" by:</P><P> <SPAN style="font-family: 'courier new', courier;">RangeSum(Below(TOTAL Sum(InvoiceQuantity),1,12))</SPAN></P><P></P><P>The problem with this, is that I'm stuck with this specific order. I want to remove this dependency.</P><P>Also, I can only calculate the RangeSum on values I'm displaying in the table. If I filter out a month, say ReportingMonth 9, then my "Prev Month" value loses that number.</P><P></P><P>I want to be able to calculate this sum, even if the months needed for the calculation aren't displayed in the table (filtered out, for example).</P><P><IMG alt="Screenshot_1.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/144130_Screenshot_1.png" style="height: 479px; width: 620px;" /></P></BODY></HTML> Thu, 17 Nov 2016 10:50:33 GMT 2016-11-17T10:50:33Z Result based on previous months https://community.qlik.com/t5/QlikView/Result-based-on-previous-months/m-p/1266344#M398898 <HTML><HEAD></HEAD><BODY><P>Hi, I'm trying to sum 12 values for each month, based on the "ThisMonth" values of the previous 12 months.</P><P>ThisMonth is just a sum: <SPAN style="font-family: 'courier new', courier;">Sum(InvoiceQuantity)</SPAN></P><P></P><P>And for the sake of this demo, I've been able to calculate "Prev Months" by:</P><P> <SPAN style="font-family: 'courier new', courier;">RangeSum(Below(TOTAL Sum(InvoiceQuantity),1,12))</SPAN></P><P></P><P>The problem with this, is that I'm stuck with this specific order. I want to remove this dependency.</P><P>Also, I can only calculate the RangeSum on values I'm displaying in the table. If I filter out a month, say ReportingMonth 9, then my "Prev Month" value loses that number.</P><P></P><P>I want to be able to calculate this sum, even if the months needed for the calculation aren't displayed in the table (filtered out, for example).</P><P><IMG alt="Screenshot_1.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/144130_Screenshot_1.png" style="height: 479px; width: 620px;" /></P></BODY></HTML> Thu, 17 Nov 2016 10:50:33 GMT https://community.qlik.com/t5/QlikView/Result-based-on-previous-months/m-p/1266344#M398898 2016-11-17T10:50:33Z Re: Result based on previous months https://community.qlik.com/t5/QlikView/Result-based-on-previous-months/m-p/1266345#M398899 <HTML><HEAD></HEAD><BODY><P>Have a look at this</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table#comment-49905" title="https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table#comment-49905">https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table#comment-49905</A></P></BODY></HTML> Thu, 17 Nov 2016 11:04:57 GMT https://community.qlik.com/t5/QlikView/Result-based-on-previous-months/m-p/1266345#M398899 stigchel 2016-11-17T11:04:57Z