topic Current Year (CY) Growth in App Development https://community.qlik.com/t5/App-Development/Current-Year-CY-Growth/m-p/2491057#M102046 <P>I have a table with two fields: 'Month' and 'Sales.' I want to calculate the Current Year (CY) Growth based on these fields.</P> <TABLE width="148"> <TBODY> <TR> <TD width="84">Month</TD> <TD width="64">Sales</TD> </TR> <TR> <TD>Apr-23</TD> <TD>10</TD> </TR> <TR> <TD>May-23</TD> <TD>16</TD> </TR> <TR> <TD>Jun-23</TD> <TD>22</TD> </TR> <TR> <TD>Jul-23</TD> <TD>28</TD> </TR> <TR> <TD>Aug-23</TD> <TD>34</TD> </TR> <TR> <TD>Sep-23</TD> <TD>40</TD> </TR> <TR> <TD>Oct-23</TD> <TD>46</TD> </TR> <TR> <TD>Nov-23</TD> <TD>52</TD> </TR> <TR> <TD>Dec-23</TD> <TD>58</TD> </TR> <TR> <TD>Jan-24</TD> <TD>64</TD> </TR> <TR> <TD>Feb-24</TD> <TD>70</TD> </TR> <TR> <TD>Mar-24</TD> <TD>76</TD> </TR> <TR> <TD>Apr-24</TD> <TD>82</TD> </TR> <TR> <TD>May-24</TD> <TD>88</TD> </TR> <TR> <TD>Jun-24</TD> <TD>94</TD> </TR> <TR> <TD>Jul-24</TD> <TD>100</TD> </TR> <TR> <TD>Aug-24</TD> <TD>106</TD> </TR> <TR> <TD>Sep-24</TD> <TD>112</TD> </TR> <TR> <TD>Oct-24</TD> <TD>118</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Below is my output:</P> <TABLE width="412"> <TBODY> <TR> <TD width="103">Month_Date</TD> <TD width="103">CY</TD> <TD width="103">LY</TD> <TD width="103">CY Growth</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>700</TD> <TD>196</TD> <TD>257%</TD> </TR> <TR> <TD>Apr-23</TD> <TD>0</TD> <TD>10</TD> <TD>-100%</TD> </TR> <TR> <TD>May-23</TD> <TD>0</TD> <TD>16</TD> <TD>-100%</TD> </TR> <TR> <TD>Jun-23</TD> <TD>0</TD> <TD>22</TD> <TD>-100%</TD> </TR> <TR> <TD>Jul-23</TD> <TD>0</TD> <TD>28</TD> <TD>-100%</TD> </TR> <TR> <TD>Aug-23</TD> <TD>0</TD> <TD>34</TD> <TD>-100%</TD> </TR> <TR> <TD>Sep-23</TD> <TD>0</TD> <TD>40</TD> <TD>-100%</TD> </TR> <TR> <TD>Oct-23</TD> <TD>0</TD> <TD>46</TD> <TD>-100%</TD> </TR> <TR> <TD>Apr-24</TD> <TD>82</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>May-24</TD> <TD>88</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>Jun-24</TD> <TD>94</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>Jul-24</TD> <TD>100</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>Aug-24</TD> <TD>106</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>Sep-24</TD> <TD>112</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>Oct-24</TD> <TD>118</TD> <TD>0</TD> <TD>-</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want below Output:</P> <TABLE width="412"> <TBODY> <TR> <TD width="103">MonthName</TD> <TD width="103">CY</TD> <TD width="103">LY</TD> <TD width="103">CY Growth</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>700</TD> <TD>196</TD> <TD>257%</TD> </TR> <TR> <TD>Apr-24</TD> <TD>82</TD> <TD>10</TD> <TD>720%</TD> </TR> <TR> <TD>May-24</TD> <TD>88</TD> <TD>16</TD> <TD>450%</TD> </TR> <TR> <TD>Jun-24</TD> <TD>94</TD> <TD>22</TD> <TD>327%</TD> </TR> <TR> <TD>Jul-24</TD> <TD>100</TD> <TD>28</TD> <TD>257%</TD> </TR> <TR> <TD>Aug-24</TD> <TD>106</TD> <TD>34</TD> <TD>212%</TD> </TR> <TR> <TD>Sep-24</TD> <TD>112</TD> <TD>40</TD> <TD>180%</TD> </TR> <TR> <TD>Oct-24</TD> <TD>118</TD> <TD>46</TD> <TD>157%</TD> </TR> </TBODY> </TABLE> Fri, 15 Nov 2024 20:50:33 GMT sachin1 2024-11-15T20:50:33Z Current Year (CY) Growth https://community.qlik.com/t5/App-Development/Current-Year-CY-Growth/m-p/2491057#M102046 <P>I have a table with two fields: 'Month' and 'Sales.' I want to calculate the Current Year (CY) Growth based on these fields.</P> <TABLE width="148"> <TBODY> <TR> <TD width="84">Month</TD> <TD width="64">Sales</TD> </TR> <TR> <TD>Apr-23</TD> <TD>10</TD> </TR> <TR> <TD>May-23</TD> <TD>16</TD> </TR> <TR> <TD>Jun-23</TD> <TD>22</TD> </TR> <TR> <TD>Jul-23</TD> <TD>28</TD> </TR> <TR> <TD>Aug-23</TD> <TD>34</TD> </TR> <TR> <TD>Sep-23</TD> <TD>40</TD> </TR> <TR> <TD>Oct-23</TD> <TD>46</TD> </TR> <TR> <TD>Nov-23</TD> <TD>52</TD> </TR> <TR> <TD>Dec-23</TD> <TD>58</TD> </TR> <TR> <TD>Jan-24</TD> <TD>64</TD> </TR> <TR> <TD>Feb-24</TD> <TD>70</TD> </TR> <TR> <TD>Mar-24</TD> <TD>76</TD> </TR> <TR> <TD>Apr-24</TD> <TD>82</TD> </TR> <TR> <TD>May-24</TD> <TD>88</TD> </TR> <TR> <TD>Jun-24</TD> <TD>94</TD> </TR> <TR> <TD>Jul-24</TD> <TD>100</TD> </TR> <TR> <TD>Aug-24</TD> <TD>106</TD> </TR> <TR> <TD>Sep-24</TD> <TD>112</TD> </TR> <TR> <TD>Oct-24</TD> <TD>118</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Below is my output:</P> <TABLE width="412"> <TBODY> <TR> <TD width="103">Month_Date</TD> <TD width="103">CY</TD> <TD width="103">LY</TD> <TD width="103">CY Growth</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>700</TD> <TD>196</TD> <TD>257%</TD> </TR> <TR> <TD>Apr-23</TD> <TD>0</TD> <TD>10</TD> <TD>-100%</TD> </TR> <TR> <TD>May-23</TD> <TD>0</TD> <TD>16</TD> <TD>-100%</TD> </TR> <TR> <TD>Jun-23</TD> <TD>0</TD> <TD>22</TD> <TD>-100%</TD> </TR> <TR> <TD>Jul-23</TD> <TD>0</TD> <TD>28</TD> <TD>-100%</TD> </TR> <TR> <TD>Aug-23</TD> <TD>0</TD> <TD>34</TD> <TD>-100%</TD> </TR> <TR> <TD>Sep-23</TD> <TD>0</TD> <TD>40</TD> <TD>-100%</TD> </TR> <TR> <TD>Oct-23</TD> <TD>0</TD> <TD>46</TD> <TD>-100%</TD> </TR> <TR> <TD>Apr-24</TD> <TD>82</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>May-24</TD> <TD>88</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>Jun-24</TD> <TD>94</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>Jul-24</TD> <TD>100</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>Aug-24</TD> <TD>106</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>Sep-24</TD> <TD>112</TD> <TD>0</TD> <TD>-</TD> </TR> <TR> <TD>Oct-24</TD> <TD>118</TD> <TD>0</TD> <TD>-</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want below Output:</P> <TABLE width="412"> <TBODY> <TR> <TD width="103">MonthName</TD> <TD width="103">CY</TD> <TD width="103">LY</TD> <TD width="103">CY Growth</TD> </TR> <TR> <TD>&nbsp;</TD> <TD>700</TD> <TD>196</TD> <TD>257%</TD> </TR> <TR> <TD>Apr-24</TD> <TD>82</TD> <TD>10</TD> <TD>720%</TD> </TR> <TR> <TD>May-24</TD> <TD>88</TD> <TD>16</TD> <TD>450%</TD> </TR> <TR> <TD>Jun-24</TD> <TD>94</TD> <TD>22</TD> <TD>327%</TD> </TR> <TR> <TD>Jul-24</TD> <TD>100</TD> <TD>28</TD> <TD>257%</TD> </TR> <TR> <TD>Aug-24</TD> <TD>106</TD> <TD>34</TD> <TD>212%</TD> </TR> <TR> <TD>Sep-24</TD> <TD>112</TD> <TD>40</TD> <TD>180%</TD> </TR> <TR> <TD>Oct-24</TD> <TD>118</TD> <TD>46</TD> <TD>157%</TD> </TR> </TBODY> </TABLE> Fri, 15 Nov 2024 20:50:33 GMT https://community.qlik.com/t5/App-Development/Current-Year-CY-Growth/m-p/2491057#M102046 sachin1 2024-11-15T20:50:33Z Re: Current Year (CY) Growth https://community.qlik.com/t5/App-Development/Current-Year-CY-Growth/m-p/2491163#M102054 <P>Hello,</P> <P>You have to create a field "month" without the year and replace the field monthname by your new field.</P> <P>Regards,</P> Wed, 06 Nov 2024 15:04:51 GMT https://community.qlik.com/t5/App-Development/Current-Year-CY-Growth/m-p/2491163#M102054 VBD 2024-11-06T15:04:51Z Re: Current Year (CY) Growth https://community.qlik.com/t5/App-Development/Current-Year-CY-Growth/m-p/2491183#M102058 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/251506">@sachin1</a>&nbsp; try below. Assuming your Month is already formatted as Numeric.</P> <LI-CODE lang="javascript">CY = sum({&lt;Month={"=sum(aggr(above(sum(Sales),12),(Month,(NUMERIC))))&gt;0"}&gt;}Sales) PY =sum(aggr(above(sum(Sales),12),(Month,(NUMERIC)))) Growth = Column(1)/Column(2)-1 </LI-CODE> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-11-06 at 16.44.19.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/173919iEE94F6BD601B3D33/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2024-11-06 at 16.44.19.png" alt="Screenshot 2024-11-06 at 16.44.19.png" /></span></P> <P>&nbsp;</P> Wed, 06 Nov 2024 16:44:48 GMT https://community.qlik.com/t5/App-Development/Current-Year-CY-Growth/m-p/2491183#M102058 Kushal_Chawda 2024-11-06T16:44:48Z