topic Creating rolling 12 value depending on month in QlikView https://community.qlik.com/t5/QlikView/Creating-rolling-12-value-depending-on-month/m-p/1393729#M819934 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have a graph with monthly values (last 24 month - working fine) and rolling 12 values (picture 1) and its OK when no selection of month. But when I select a month <SPAN style="font-size: 10pt;">the rolling values only shows on the selected month (picture 2). I would like to present the rolling 12 to the selected month and then 12 month back.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">and if possible show the data for a 24 month period as the monthly value</SPAN></P><P></P><P>Today I use the following syntax with :</P><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="color: #0433ff;">sum</SPAN><SPAN style="color: #000000;">( </SPAN><SPAN style="color: #0433ff;">aggr</SPAN><SPAN style="color: #000000;">( </SPAN><SPAN style="color: #0433ff;">rangesum</SPAN><SPAN style="color: #000000;">( </SPAN><SPAN style="color: #0433ff;">above</SPAN><SPAN style="color: #000000;">( </SPAN><SPAN style="color: #0433ff;">sum</SPAN><SPAN style="color: #000000;">( {$&lt;</SPAN><SPAN style="color: #941100;">[YearMonth]</SPAN><SPAN style="color: #000000;">&gt;}&nbsp; </SPAN><SPAN style="color: #941100;">Revenue</SPAN><SPAN style="color: #000000;">),0,12) ),</SPAN><SPAN style="color: #941100;">[YearMonth]</SPAN><SPAN style="color: #000000;">)) </SPAN></P><P style="font-size: 9px; font-family: 'Courier New';"></P><P><SPAN style="color: #000000;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Creating rolling 12 value depending on month https://community.qlik.com/t5/QlikView/Creating-rolling-12-value-depending-on-month/m-p/1393729#M819934 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have a graph with monthly values (last 24 month - working fine) and rolling 12 values (picture 1) and its OK when no selection of month. But when I select a month <SPAN style="font-size: 10pt;">the rolling values only shows on the selected month (picture 2). I would like to present the rolling 12 to the selected month and then 12 month back.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">and if possible show the data for a 24 month period as the monthly value</SPAN></P><P></P><P>Today I use the following syntax with :</P><P style="font-size: 9px; font-family: 'Courier New';"><SPAN style="color: #0433ff;">sum</SPAN><SPAN style="color: #000000;">( </SPAN><SPAN style="color: #0433ff;">aggr</SPAN><SPAN style="color: #000000;">( </SPAN><SPAN style="color: #0433ff;">rangesum</SPAN><SPAN style="color: #000000;">( </SPAN><SPAN style="color: #0433ff;">above</SPAN><SPAN style="color: #000000;">( </SPAN><SPAN style="color: #0433ff;">sum</SPAN><SPAN style="color: #000000;">( {$&lt;</SPAN><SPAN style="color: #941100;">[YearMonth]</SPAN><SPAN style="color: #000000;">&gt;}&nbsp; </SPAN><SPAN style="color: #941100;">Revenue</SPAN><SPAN style="color: #000000;">),0,12) ),</SPAN><SPAN style="color: #941100;">[YearMonth]</SPAN><SPAN style="color: #000000;">)) </SPAN></P><P style="font-size: 9px; font-family: 'Courier New';"></P><P><SPAN style="color: #000000;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Creating-rolling-12-value-depending-on-month/m-p/1393729#M819934 2020-11-25T16:16:04Z Re: Creating rolling 12 value depending on month https://community.qlik.com/t5/QlikView/Creating-rolling-12-value-depending-on-month/m-p/1393730#M819935 <HTML><HEAD></HEAD><BODY><P>Check this link.</P><P></P><P><A href="https://community.qlik.com/thread/249357">How to do rolling 12 months sum</A></P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Sun, 13 Aug 2017 06:35:18 GMT https://community.qlik.com/t5/QlikView/Creating-rolling-12-value-depending-on-month/m-p/1393730#M819935 kaushiknsolanki 2017-08-13T06:35:18Z