topic Problem with rolling 12 months in QlikView https://community.qlik.com/t5/QlikView/Problem-with-rolling-12-months/m-p/679365#M246365 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>Please give me a solution for below scenario:</P><P></P><P>i am showing rolling 12 months data in the chart for that i am using below condition in the expression:</P><P>Date=,Month=,Year_No=,Month_Year={'&gt;$(vMaxMonthYear_PY12) &lt;=$(vMaxYearMonth)'} </P><P></P><P>by using this i am calculating the Current Year Values and Previous year value, and also Change between CY and PY,</P><P></P><P>when i am taking month in the chart it is working fine, but when i am taking month-Year in the chart it is not showing any value</P><P></P><P>can anybody please help into that.</P></BODY></HTML> Wed, 24 Sep 2014 07:17:34 GMT 2014-09-24T07:17:34Z Problem with rolling 12 months https://community.qlik.com/t5/QlikView/Problem-with-rolling-12-months/m-p/679365#M246365 <HTML><HEAD></HEAD><BODY><P>Hello Everyone,</P><P></P><P>Please give me a solution for below scenario:</P><P></P><P>i am showing rolling 12 months data in the chart for that i am using below condition in the expression:</P><P>Date=,Month=,Year_No=,Month_Year={'&gt;$(vMaxMonthYear_PY12) &lt;=$(vMaxYearMonth)'} </P><P></P><P>by using this i am calculating the Current Year Values and Previous year value, and also Change between CY and PY,</P><P></P><P>when i am taking month in the chart it is working fine, but when i am taking month-Year in the chart it is not showing any value</P><P></P><P>can anybody please help into that.</P></BODY></HTML> Wed, 24 Sep 2014 07:17:34 GMT https://community.qlik.com/t5/QlikView/Problem-with-rolling-12-months/m-p/679365#M246365 2014-09-24T07:17:34Z Re: Problem with rolling 12 months https://community.qlik.com/t5/QlikView/Problem-with-rolling-12-months/m-p/679366#M246366 <HTML><HEAD></HEAD><BODY><P>May be below would be useful to you...</P><P><A href="https://community.qlik.com/docs/DOC-4252">Calculating rolling n-period totals, averages or other aggregations</A></P></BODY></HTML> Wed, 24 Sep 2014 07:43:22 GMT https://community.qlik.com/t5/QlikView/Problem-with-rolling-12-months/m-p/679366#M246366 MK_QSL 2014-09-24T07:43:22Z