topic Re: Set Analysis (Rolling Expression) in App Development https://community.qlik.com/t5/App-Development/Set-Analysis-Rolling-Expression/m-p/1778574#M60496 <P>Perhaps this?</P><P><SPAN>Sum(Aggr(Sum({&lt;Date = {"&gt;=$(=MonthStart(AddMonths(Date(Max(Date)),-9)))</SPAN><BR /><SPAN>&lt;=$(=Monthend(AddMonths(Date(Max(Date)),2)))"}&gt;}Sales), Dim1, Dim2))</SPAN></P> Fri, 29 Jan 2021 19:42:56 GMT Anil_Babu_Samineni 2021-01-29T19:42:56Z Set Analysis (Rolling Expression) https://community.qlik.com/t5/App-Development/Set-Analysis-Rolling-Expression/m-p/1778324#M60459 <P>Hello Guys,</P><P>Help me in below set expression , not able to achieve this from long time.</P><P>Requirement is to get the Rolling of sales</P><P>Time period to considered is (Previous 9 months + Current Month + Next 2 months)</P><P>Below is the sample data, mentioned rolling period below for understanding.</P><P>Same KPI is Used in Tables charts, KPI box.</P><P>Expression i tried is as below.</P><P>Sum({&lt;Date = {"&gt;=$(=MonthStart(AddMonths(Date(Max(Date)),-9)))<BR />&lt;=$(=Monthend(AddMonths(Date(Max(Date)),2)))"}&gt;}Sales)</P><P>Issue:Max date should calculate row level in table, but above expression max date is calculated on whole App.</P><P>I can't use Range sum because some months data is missing and also the same kpi is mentioned in KPI Box and many charts with lowest granularity.</P><P>Thanks in Advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Product</TD><TD>Date</TD><TD>Year</TD><TD>Month</TD><TD>Sales</TD><TD>Sales_Pred</TD><TD>Rolling Period to be considered(Prev 9 + CurMon + Next 2)</TD></TR><TR><TD>P01</TD><TD>4/1/2020</TD><TD>2020</TD><TD>4</TD><TD>100</TD><TD>330</TD><TD>04/2020 to 06/2020</TD></TR><TR><TD>P01</TD><TD>5/2/2020</TD><TD>2020</TD><TD>5</TD><TD>110</TD><TD>460</TD><TD>04/2020 to 07/2020</TD></TR><TR><TD>P01</TD><TD>6/2/2020</TD><TD>2020</TD><TD>6</TD><TD>120</TD><TD>600</TD><TD>04/2020 to 08/2020</TD></TR><TR><TD>P01</TD><TD>7/3/2020</TD><TD>2020</TD><TD>7</TD><TD>130</TD><TD>750</TD><TD>04/2020 to 09/2020</TD></TR><TR><TD>P01</TD><TD>8/3/2020</TD><TD>2020</TD><TD>8</TD><TD>140</TD><TD>910</TD><TD>04/2020 to 10/2020</TD></TR><TR><TD>P01</TD><TD>9/3/2020</TD><TD>2020</TD><TD>9</TD><TD>150</TD><TD>1080</TD><TD>04/2020 to 11/2020</TD></TR><TR><TD>P01</TD><TD>10/4/2020</TD><TD>2020</TD><TD>10</TD><TD>160</TD><TD>1280</TD><TD>04/2020 to 12/2020</TD></TR><TR><TD>P01</TD><TD>11/4/2020</TD><TD>2020</TD><TD>11</TD><TD>170</TD><TD>1460</TD><TD>04/2020 to 01/2021</TD></TR><TR><TD>P01</TD><TD>12/5/2020</TD><TD>2020</TD><TD>12</TD><TD>200</TD><TD>1620</TD><TD>04/2020 to 02/2021</TD></TR><TR><TD>P01</TD><TD>1/5/2021</TD><TD>2021</TD><TD>1</TD><TD>180</TD><TD>1760</TD><TD>04/2020 to 03/2021</TD></TR><TR><TD>P01</TD><TD>2/5/2021</TD><TD>2021</TD><TD>2</TD><TD>160</TD><TD>1780</TD><TD>05/2020 to 04/2021</TD></TR><TR><TD>P01</TD><TD>3/8/2021</TD><TD>2021</TD><TD>3</TD><TD>140</TD><TD>1770</TD><TD>06/2020 to 05/2021</TD></TR><TR><TD>P01</TD><TD>4/8/2021</TD><TD>2021</TD><TD>4</TD><TD>120</TD><TD>1650</TD><TD>07/2020 to 06/2021</TD></TR><TR><TD>P01</TD><TD>5/9/2021</TD><TD>2021</TD><TD>5</TD><TD>100</TD><TD>1520</TD><TD>08/2020 to 07/2021</TD></TR><TR><TD>P02</TD><TD>4/1/2020</TD><TD>2020</TD><TD>4</TD><TD>80</TD><TD>180</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>5/2/2020</TD><TD>2020</TD><TD>5</TD><TD>60</TD><TD>200</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>6/2/2020</TD><TD>2020</TD><TD>6</TD><TD>40</TD><TD>330</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>7/3/2020</TD><TD>2020</TD><TD>7</TD><TD>20</TD><TD>490</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>8/3/2020</TD><TD>2020</TD><TD>8</TD><TD>130</TD><TD>680</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>9/3/2020</TD><TD>2020</TD><TD>9</TD><TD>160</TD><TD>900</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>10/4/2020</TD><TD>2020</TD><TD>10</TD><TD>190</TD><TD>1150</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>11/4/2020</TD><TD>2020</TD><TD>11</TD><TD>220</TD><TD>1430</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>12/5/2020</TD><TD>2020</TD><TD>12</TD><TD>250</TD><TD>1740</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>1/5/2021</TD><TD>2021</TD><TD>1</TD><TD>280</TD><TD>2080</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>2/5/2021</TD><TD>2021</TD><TD>2</TD><TD>310</TD><TD>2370</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>3/8/2021</TD><TD>2021</TD><TD>3</TD><TD>340</TD><TD>2710</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>4/8/2021</TD><TD>2021</TD><TD>4</TD><TD>370</TD><TD>2670</TD><TD>&nbsp;</TD></TR><TR><TD>P02</TD><TD>5/9/2021</TD><TD>2021</TD><TD>5</TD><TD>400</TD><TD>2650</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 00:43:48 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Rolling-Expression/m-p/1778324#M60459 qlik4asif 2024-11-16T00:43:48Z Re: Set Analysis (Rolling Expression) https://community.qlik.com/t5/App-Development/Set-Analysis-Rolling-Expression/m-p/1778574#M60496 <P>Perhaps this?</P><P><SPAN>Sum(Aggr(Sum({&lt;Date = {"&gt;=$(=MonthStart(AddMonths(Date(Max(Date)),-9)))</SPAN><BR /><SPAN>&lt;=$(=Monthend(AddMonths(Date(Max(Date)),2)))"}&gt;}Sales), Dim1, Dim2))</SPAN></P> Fri, 29 Jan 2021 19:42:56 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Rolling-Expression/m-p/1778574#M60496 Anil_Babu_Samineni 2021-01-29T19:42:56Z Re: Set Analysis (Rolling Expression) https://community.qlik.com/t5/App-Development/Set-Analysis-Rolling-Expression/m-p/1778703#M60520 <P>Thanks for the reply ,</P><P>But expression is not working</P> Sun, 31 Jan 2021 13:51:51 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Rolling-Expression/m-p/1778703#M60520 qlik4asif 2021-01-31T13:51:51Z