topic Re: Rolling Month Calculation in QlikView https://community.qlik.com/t5/QlikView/Rolling-Month-Calculation/m-p/514272#M1136161 <HTML><HEAD></HEAD><BODY><P>Good afternoon Friend!</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">There are several different ways to create this table, everything will depend on the context of your need. Improve your request, sending practical examples and a better explanation.</SPAN></P><P></P><P>Thank you!</P></BODY></HTML> Wed, 23 Oct 2013 16:43:09 GMT offjunior 2013-10-23T16:43:09Z Rolling Month Calculation https://community.qlik.com/t5/QlikView/Rolling-Month-Calculation/m-p/514270#M1136159 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I need to create a table like this</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Purchase #&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Purchase $</P><P>3 Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $2349&nbsp;&nbsp;&nbsp; </P><P>6 Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $3490</P><P>12 Month&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $3490</P><P>YTD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $3490</P><P></P><P>By default month is Current Month -1 . Can please someone help me to solve this issue? I belive I can do it on Set Analysis.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 23 Oct 2013 16:09:17 GMT https://community.qlik.com/t5/QlikView/Rolling-Month-Calculation/m-p/514270#M1136159 2013-10-23T16:09:17Z Re: Rolling Month Calculation https://community.qlik.com/t5/QlikView/Rolling-Month-Calculation/m-p/514271#M1136160 <HTML><HEAD></HEAD><BODY><P>HI</P><P>you can use calculated dimension to do this. Click on calculated dimension button and write the formula</P></BODY></HTML> Wed, 23 Oct 2013 16:31:10 GMT https://community.qlik.com/t5/QlikView/Rolling-Month-Calculation/m-p/514271#M1136160 2013-10-23T16:31:10Z Re: Rolling Month Calculation https://community.qlik.com/t5/QlikView/Rolling-Month-Calculation/m-p/514272#M1136161 <HTML><HEAD></HEAD><BODY><P>Good afternoon Friend!</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">There are several different ways to create this table, everything will depend on the context of your need. Improve your request, sending practical examples and a better explanation.</SPAN></P><P></P><P>Thank you!</P></BODY></HTML> Wed, 23 Oct 2013 16:43:09 GMT https://community.qlik.com/t5/QlikView/Rolling-Month-Calculation/m-p/514272#M1136161 offjunior 2013-10-23T16:43:09Z