topic Calculate 12 month rolling in QlikView https://community.qlik.com/t5/QlikView/Calculate-12-month-rolling/m-p/1002028#M643319 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm wondering if someone could help me.</P><P></P><P>I'm trying to display the value of the last 12 months for a calculated value (Day Payable Outstanding). At every monthyear I don't want to display the value of DPO e.g. Sep '15, but I want to display the value of DPO from Oct '14 to Sep '15.</P><P></P><P>Is that clear?</P><P></P><P>As you can se iin my qvw I can calculate the DPO in the "DPO (gg)" chart and I'm trying to calculate the DPO LTM ( last twelve months) in the "DPO LTM(gg)" chart</P><P>I tried creating a rolling period but seems that my tentative and the formulas used don't works as well.</P><P></P><P>Attach here my qvw.</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌ did u ever seen something like that?</P></BODY></HTML> Sat, 28 Nov 2015 15:07:33 GMT caccio88 2015-11-28T15:07:33Z Calculate 12 month rolling https://community.qlik.com/t5/QlikView/Calculate-12-month-rolling/m-p/1002028#M643319 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm wondering if someone could help me.</P><P></P><P>I'm trying to display the value of the last 12 months for a calculated value (Day Payable Outstanding). At every monthyear I don't want to display the value of DPO e.g. Sep '15, but I want to display the value of DPO from Oct '14 to Sep '15.</P><P></P><P>Is that clear?</P><P></P><P>As you can se iin my qvw I can calculate the DPO in the "DPO (gg)" chart and I'm trying to calculate the DPO LTM ( last twelve months) in the "DPO LTM(gg)" chart</P><P>I tried creating a rolling period but seems that my tentative and the formulas used don't works as well.</P><P></P><P>Attach here my qvw.</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">sunindia</A>‌ did u ever seen something like that?</P></BODY></HTML> Sat, 28 Nov 2015 15:07:33 GMT https://community.qlik.com/t5/QlikView/Calculate-12-month-rolling/m-p/1002028#M643319 caccio88 2015-11-28T15:07:33Z Re: Calculate 12 month rolling https://community.qlik.com/t5/QlikView/Calculate-12-month-rolling/m-p/1002029#M643320 <HTML><HEAD></HEAD><BODY><P>See: <A href="https://community.qlik.com/thread/193328">Rolling last 12 months</A></P></BODY></HTML> Sun, 29 Nov 2015 09:34:25 GMT https://community.qlik.com/t5/QlikView/Calculate-12-month-rolling/m-p/1002029#M643320 marcus_sommer 2015-11-29T09:34:25Z Re: Calculate 12 month rolling https://community.qlik.com/t5/QlikView/Calculate-12-month-rolling/m-p/1002030#M643321 <HTML><HEAD></HEAD><BODY><P>Hi Filiberto,</P><P></P><P>PFA....</P><P></P><P>Let me know the status.</P><P></P><P></P><P></P><P><STRONG>-Nagarjuna</STRONG></P></BODY></HTML> Sun, 29 Nov 2015 11:53:00 GMT https://community.qlik.com/t5/QlikView/Calculate-12-month-rolling/m-p/1002030#M643321 nagarjuna_kotha 2015-11-29T11:53:00Z