topic Rolling 13 Period in QlikView https://community.qlik.com/t5/QlikView/Rolling-13-Period/m-p/221668#M504945 <HTML><HEAD></HEAD><BODY><P>I am trying to create a line chart to show a current 13 Rolling Period and a Previous 13 Polling Period. I am able to do this when selecting a year, so I can show year over year with the following expressions</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />C13 - <B>SUM</B>({&lt;<B>fiscal_yr</B> = {<B><I>$(vCY)</I></B>}&gt;} <B>PNS_DAY</B>)<BR />PR13 - <B>SUM</B>({&lt;<B>fiscal_yr</B> = {<B><I>$(vPY)</I></B>}&gt;} <B>PNS_DAY</B>)<BR /></PRE><BR /><BR /> <P>The issue is that when I select a period it filters to just chart the selected period. I can determine the beginning and end periods need for each rolling 13 lines, but I do not know the syntax to pass that into a SET Analysis forumla. Is there a way to express a range in the Set Analysis? I tried the example from help and have not luck with it.</P><P>Any help would be greatly appreciated. I am attaching an excel spreadsheet that has sample data that represents the data I am using.</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1641.Rolling13.xls:550:0]</P><P>Thank you for your time and help,</P><P>Tyson</P><P></P></BODY></HTML> Thu, 22 Oct 2009 04:00:30 GMT 2009-10-22T04:00:30Z Rolling 13 Period https://community.qlik.com/t5/QlikView/Rolling-13-Period/m-p/221668#M504945 <HTML><HEAD></HEAD><BODY><P>I am trying to create a line chart to show a current 13 Rolling Period and a Previous 13 Polling Period. I am able to do this when selecting a year, so I can show year over year with the following expressions</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />C13 - <B>SUM</B>({&lt;<B>fiscal_yr</B> = {<B><I>$(vCY)</I></B>}&gt;} <B>PNS_DAY</B>)<BR />PR13 - <B>SUM</B>({&lt;<B>fiscal_yr</B> = {<B><I>$(vPY)</I></B>}&gt;} <B>PNS_DAY</B>)<BR /></PRE><BR /><BR /> <P>The issue is that when I select a period it filters to just chart the selected period. I can determine the beginning and end periods need for each rolling 13 lines, but I do not know the syntax to pass that into a SET Analysis forumla. Is there a way to express a range in the Set Analysis? I tried the example from help and have not luck with it.</P><P>Any help would be greatly appreciated. I am attaching an excel spreadsheet that has sample data that represents the data I am using.</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1641.Rolling13.xls:550:0]</P><P>Thank you for your time and help,</P><P>Tyson</P><P></P></BODY></HTML> Thu, 22 Oct 2009 04:00:30 GMT https://community.qlik.com/t5/QlikView/Rolling-13-Period/m-p/221668#M504945 2009-10-22T04:00:30Z Rolling 13 Period https://community.qlik.com/t5/QlikView/Rolling-13-Period/m-p/221669#M504946 <HTML><HEAD></HEAD><BODY><P>Hi Tyson,</P><P>please see the attached example.</P><P>Good luck!</P><P>Rainer</P></BODY></HTML> Thu, 22 Oct 2009 14:58:52 GMT https://community.qlik.com/t5/QlikView/Rolling-13-Period/m-p/221669#M504946 2009-10-22T14:58:52Z